SQLSERVER中FIRST_VALUE和LAST_VALUE
程序员文章站
2024-02-14 12:21:28
...
WITH test as ( select '乐可乐可的部落格' as name,10 as score UNION ALL select '乐可乐可的部落格',15 UNION ALL select '乐可乐可的部落格',20 UNION ALL select '微软认证',30 UNION ALL select '微软认证',40 UNION ALL select '微软认证',40 ) selec
WITH test
as
(
select '乐可乐可的部落格' as name,10 as score
UNION ALL
select '乐可乐可的部落格',15
UNION ALL
select '乐可乐可的部落格',20
UNION ALL
select '微软认证',30
UNION ALL
select '微软认证',40
UNION ALL
select '微软认证',40
)
select name,score
,FIRST_VALUE(score)over(order by name) as fst
,LAST_VALUE(score)over(order by name) as Lst
from test
,上一篇: MySQL外键和参照完整性的实现步骤
推荐阅读
-
SQLSERVER中FIRST_VALUE和LAST_VALUE
-
SQLSERVER中PERCENTILE_CONT和PERCENTILE_DISC
-
B-Tree索引在sqlserver和mysql中的应用
-
SQLSERVER 2005中使用sql语句对xml文件和其数据的进行操作(很全
-
SQLSERVER中FIRST_VALUE和LAST_VALUE
-
sqlserver 中EXEC和sp
-
sqlserver中的guid的40位数和36位数的获得
-
SQLSERVER中的ALL、PERCENT、CUBE关键字和GROUPING函数
-
第十七章配置SQLServer(2)32位和64位系统中的内存配置
-
MySQL和sqlserver中判断表是否存在语句_MySQL