sqlserver数据库
brookzhang1111
qq:749285327
展开
-
sql update left join
UPDATE b SET b.Address = a.ADDRESS , b.lot = a.lot , b.lat = a.lat FROM VisitPharmacy_StoreLocation a LEFT JOIN Pharmacy b ON a.PharmacyID = b.PharmacyID原创 2017-12-27 15:24:25 · 1281 阅读 · 2 评论 -
row_number() OVER (PARTITION BY COL1 ORDER BY COL2)
PARTITION BY 应用场景 表:employee 字段:deptid 部门 salary 工资 现在要统计各部门工资高低名次,首先是根据部门分组,再就是以部门为单位排列名次。要达到效果如下: 若是没有排名我们用简单排序就可查询出。但要实现图中排名就要用到PARTITION BY 语法:SELECT *, Row_Number() OVER (p...原创 2019-04-26 16:35:16 · 407 阅读 · 0 评论 -
ROW_NUMBER 分页取数据算法公式
---row_number基本查询 select * from ( select Id , PassWord , row_number() over ( order by Id desc ) RowNo--RowNo 从1开始 from dbo.T_StudentBase ...原创 2019-09-02 17:48:55 · 245 阅读 · 0 评论