1 分页排序功能按照物理表存储的顺序显示第10-30条记录select top 20 * from ( select row_number() over (oder by i_id) as rowid fromtableName ) a where rowid>10 and rowid<=302 分组汇总功能select columnA,row_number() over (partiton by columnA order by i_id ) as rowidFROM tableName按照columna进行分组,每一个columnA值rowid从1开始排序。select col Read More