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中分组后每组中的第一条或者最后一条
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
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
扫一扫
