取出每个分组的的第一条数据sql
select * from
(
select id,detail, ROW_NUMBER()over(PARTITION By detail ORDER BY detail DESC) as rn
from t_info_kind
) T
where T.rn = 1
select * from
(
select id,detail, ROW_NUMBER()over(PARTITION By detail ORDER BY detail DESC) as rn
from t_info_kind
) T
where T.rn = 1