SQL SERVER中FIRST_VALUE和LAST_VALUE
FIRST_VALUE和LAST_VALUE
看下组SQL语句:
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