over是用于数据的分区和排序,常用在函数后边使用
例如:
create table over_eg
(
row1 int,
row2 int
);
declare @int int;
set @int=1;
while @int<=50
begin
insert into over_eg values (@int,@int%5);
set @int=@int+1;
end
go
--按照row2进行分区,找出每个区里边最小的值
select min_row1=min(row1) over (partition by row2) ,row2 from over_eg;
温馨提示:答案为网友推荐,仅供参考