Strives for the SQL sentence, thank you,

CodePudding user response:

Select a. * from AAA a inner join
(select toh_id, Max (last_updated_date) as last_updated_date from AAA group by toh_id) b
On a.t oh_id=b.t oh_id and a. ast_updated_date=b.l ast_updated_date

CodePudding user response:

Thank you very much! I went to the test!