取出每个分组的的第一条数据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
本文来自博客园,作者:WantRemake,转载请注明原文链接:https://www.cnblogs.com/SmallChen/p/15020799.html
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
本文来自博客园,作者:WantRemake,转载请注明原文链接:https://www.cnblogs.com/SmallChen/p/15020799.html