declare @xx table(i int)
insert into @xx values (0)
insert into @xx values (1)
insert into @xx values (2)
select * from @xx
delete from @xx where i > (select top 1 i from @xx order by i)
select * from @xx
declare @xx table(i int)
insert into @xx values (0)
insert into @xx values (1)
insert into @xx values (2)
delete from @xx where i > (select top 1 i from @xx order by i)
select * from @xx