34,590
社区成员
发帖
与我相关
我的任务
分享
select (@i:=@i+1) as i,tablename.* from tablename,(select @i:=0) as it order by i desc limit 1
select *
from
(
select *,
count(*) over(PARTITION by 1) as record_count, --表中的记录数
ROW_NUMBER() over(order by @@servername) as rownum --人工的行号
from sys.objects
)t
where rownum = record_count