Subject selecting max date
Author Dale Tabbert

I have a query that I would like to return only one row. The primary
key on the table is the object_id, blob_type_id and the object_date
(the date the item was entered in the table). I have SQL like:

select object_date, object_sc from object_blob where object_id
= :object_id and blob_type_id = 7 and object_date = max(object_date)

I get "Invalid aggregate reference" from the above statement. How
can I do this?

Thanks to all in advance