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 SQLServer 数据库批量查找替换工具1.2 SQL木马清除助手SQLServer 数据库批量查找替换工具1.2 SQL木马清除助手下载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，
SQLSERVER中FIRST_VALUE和LAST_VALUE
•
👁 0人浏览过