declare @t table(a int) insert into @t select 1 insert into @t select 152 insert into @t select 625 insert into @t select 1525 insert into @t select 12525 insert into @t select 12525252select [id]=identity(int,1,1),* into # from @t select top 5 a from # order by id descdrop table #
insert into @t select 1
insert into @t select 152
insert into @t select 625
insert into @t select 1525
insert into @t select 12525
insert into @t select 12525252select [id]=identity(int,1,1),* into # from @t
select top 5 a from # order by id descdrop table #