sql 常用手册

根据code 分组然后取出每组中的任意一行

SELECT *from(

SELECT
*, row_number () OVER (
partition BY code
ORDER BY
code DESC
) rowid
FROM
dept

) t

WHERE
rowid = 1;

 

SQL中相关子查询

https://www.cnblogs.com/xcyjblog/p/14841168.html

 

SQL Server 事务隔离级别

https://www.cnblogs.com/chenmh/p/3998614.html

 

 

SQLServer提取日期

https://www.cnblogs.com/mazey/p/6517744.html

posted @ 2023-06-09 20:43  flan_grean  阅读(5)  评论(0编辑  收藏  举报