declare @s int
set @s=1
for (@s<=(select count(*) from a where 入库金额 between 500 and 1000 ))
set @s=@s+1
select @s as iid,* from a where 入库金额 between 500 and 1000 order by 入库金额 desc
set @s=1
for (@s<=(select count(*) from a where 入库金额 between 500 and 1000 ))
set @s=@s+1
select @s as iid,* from a where 入库金额 between 500 and 1000 order by 入库金额 desc
不就可以了