MySQL Forums
Forum List  »  Newbie

Re: selecting the max of a column
Posted by: laptop alias
Date: May 07, 2008 01:04AM

SELECT t1.*
FROM my_table t1
LEFT JOIN my_table t2
ON t1.grouping_id = t2.grouping_id
AND t1.ordering_id < t2.ordering_id
WHERE t2.any_indexed_field IS NULL;

Options: ReplyQuote


Subject
Written By
Posted
Re: selecting the max of a column
May 07, 2008 01:04AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.