7,714
社区成员
发帖
与我相关
我的任务
分享
select col0,col1,col2 from table1
where col0 in
(select Min(col0) from table1
Group by col1) order by col1
select a.*
from table1 a inner join (select col1, Min(col0) as m from table1 Group by col1) b
on a.col1=b.col1 and col0=b.m
order by a.col1