I've got a table with fields bookingId, quoteId, bookingDate
I want to get the max(bookingDate) for the max(bookingId) for a given
quoteId

select bookingId, max(bookingDate) from table where quoteId = 1 group
by bookingId
gives me the max date for each bookingId

select quoteId, max(bookingId), max(bookingDate) from table where
quoteId = 1 group by quoteId
gives me the max bookingId and the max date, but not the max date of
the max bookingId

do I need two queries to do this ?

Roger wrote:
Create a saved query that gives you the max booking id for each quoteid.
Then create a new query that joins the table to the saved query using
quoteid and booking id-maxbookingid.

"Bob Barrows" <reb01501 (AT) NOSPAMyahoo (DOT) com> skrev i en meddelelse
news:j9m5jb$tli$1 (AT) dont-email (DOT) me...
Alternatively you could use a subselect:

select quoteid, bookingid, max(bookingdate) as bookingdate
from yourtable as t1
where bookingid = (select max(bookingid) from yourtable where
quoteid=t1.quoteid)
group by quoteid, bookingid

However, subselect have a bad reputation for being slow and thus isn't
recommended with big tables.