select * from ( select row_number() over( order by xxx desc) as rownum, id,time,a,b,c,d from table where a=1 and b=0 ) as t where rownum>0 and rownum<=20

最后修改：2020 年 11 月 29 日
© 允许规范转载
如果觉得我的文章对你有用，请随意赞赏