In a DBMS featuring subqueries, this is easy: SELECT sent_id, subs_id FROM sent AS outer_sent WHERE sent_id = ( SELECT sent_id FROM sent WHERE subs_id = outer_sent.subs_id ORDER BY date_created DESC ...