Late to reply, but figured I’d add another solution in case someone wants it. If you are willing to use a derived table to build the view, you can always doselect *, (select max(date) from MYTABLE) as max_datefrom MYTABLEand then use max_date = date ...