sql:
select * from (select row_number () over(partition by set_id order by last_end_time desc) rowId,* from zx_sync_log)t where rowId=1
印象中好像 sqlserver 数据库也是这样干的
sql:
select * from (select row_number () over(partition by set_id order by last_end_time desc) rowId,* from zx_sync_log)t where rowId=1
印象中好像 sqlserver 数据库也是这样干的