求简单SQL语句,号码重复的,最时间最大的记录

[xwqjamky]

id sj
1 45
1 65
1 76
2 98
2 65
3 64
4 12
4 25


id 重复的,只取SJ最大的记录
id sj
1 76
2 98
3 64
4 25

[lwl0606]

select *
from table01 a
where not exists (select 1 from table01 b where a.id=b.id and a.sj<b.sj)

[wwwwb]

select id,max(sj) from tt group by id

[gahade]

select id,max(sj) sj from 表 group by id

[bill024]

select id,max(sj) from t group by id

[hrb2008]

select id ,max(sj) as sj from tb group by id

[wenyang2004]

select max(sj) from TABLE1 group by id