selecting based on a max() condition

Hi, I have a table with 3 relevant columns: symbol varchar(10) not null price decimal not null and last_update datetime not null I want to select the list of unique symbols and the corresponding price and last_update fields for each line where the last_update is equal to the last_update field

Re: selecting based on a max() condition

Octavian, I want to select the list of unique symbols and the corresponding price and last_update fields for each line where the last_update is equal to the last_update field for each symbol. You're close! See the example at http://www.artfulsoftware.com/queries.php#18. PB - Octavian