select * from(select row_number()
over(partition by 【分组列】 order by 【排序列】desc/asc) as rownum,*
from (SELECT
*
FROM
【表名】
)as G1 ) as G where G.rownum =1
查询sql中分组后每组中的第一条或者最后一条
最新推荐文章于 2022-06-23 17:33:03 发布
select * from(select row_number()
over(partition by 【分组列】 order by 【排序列】desc/asc) as rownum,*
from (SELECT
*
FROM
【表名】
)as G1 ) as G where G.rownum =1