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 日 07 : 05 PM