declare @toarows int,@k int select @totrows=count(*) frow yourtable select @k=0 declare getrow cursor for select * from yourtable open getrow fetch next from getrow while ( @@fetch_status = 0 ) begin select @k=@k+1 if @totrows-@k>=10 fetch next from getrow else begin --处理最后10行 ...... fetch next from getrow end end
而且都是CHAR储存,没有时间或ID
就单纯叫出最后存的10笔数据
我想从最下面取10笔 没有这种语法吗?
select @totrows=count(*) frow yourtable
select @k=0
declare getrow cursor for select * from yourtable
open getrow
fetch next from getrow
while ( @@fetch_status = 0 )
begin
select @k=@k+1
if @totrows-@k>=10
fetch next from getrow
else
begin
--处理最后10行
......
fetch next from getrow
end
end