前置条件
1、表:employ
2、包含2个字段:dept和name字段
-- 按照dept字段分组汇总,按照name字段进行组内排序
select
ROW_NUMBER() OVER (PARTITION BY dept ORDER BY name )
, * from Employ
-- 按照name字段进行排序
select
ROW_NUMBER() OVER ( ORDER BY name )
, * from Employ
-- 按照name字段进行排序 ,获取其中第12到23的范围数据
select * from (
select
ROW_NUMBER() OVER ( ORDER BY name ) rownum
, * from Employ) temptable
where rownum between 12 and 23