分页
declare @b int
set @b=5
declare @a table(id int identity,info varchar(20))
insert into @a select loginid from student
while exists(select * from @a)
begin
select top 5 info from @a
delete from @a where id<=@b
set @b=@b+5
end
最近年龄
declare @b int
set @b=20
--1
select * from (select rank() over (order by abs(stuage-@b)) a,* from stuinfo) aa
where aa.a=1
--2
select * from stuinfo where abs(stuage-@b)=
(select top 1 abs(stuage-@b) from stuinfo order by abs(stuage-@b))
--3
select * from stuinfo where abs(stuage-@b)=
(select min(abs(stuage-@b)) from stuinfo)