Delete Top n-1 from a groud of records of a table

 

Test successfully!

 

declare @num int;
select @num=count(*) from budget where fk_project_id=62;

declare @topstr nVARCHAR(256);
set @topstr='select top'+str(@num) +' * from budget'; 

execute sp_executesql @topstr ;