sql分页，分组排序

var list=arr.GroupBy(d => d.Product, (d, v) => new {groupbyid = d, grouplist = v}).ToList();

第一种方法
ORDER BY UtcCreateAt DESC OFFSET (@pageindex - 1)*@pagesize ROWS FETCH NEXT @pagesize ROWS ONLY

第二种方法
编号
select ROW_NUMBER() OVER(order by S.CreateTime desc) AS RowNumber,

select * from #table1 where (RowNumber Between (@pageindex1 - 1)*@pagesize+1 and @pageindex1 * @pagesize) order by #table1.OperTime desc

–分班后按学生成绩排名
select *,row_number() over(partition by Grade order by Score desc) as Sequence from Student

id Grade Score Sequence

---

1 1 88 1
3 1 75 2
2 1 66 3
6 2 80 1
5 2 70 2
7 2 60 3
4 2 30 4
8 3 90 1
10 3 80 2
9 3 70 3

sql 查看锁
select * from sys.dm_tran_locks

sql公用表达式
with result(wid,wname,dname) as
(
select wid,wname,dname
from worker inner join depart on worker.depid=depart.did
where dname=‘人事处’
)
select result.wid as 职工号,wname as 姓名,dname as 部门名,sdate as 发工资日期,actualsalary as 实发工资
from result inner join salary on result.wid=salary.wid