1、红色字体为两表联合部分
2、倒序加分页查询
SELECT * FROM ( SELECT ROW_NUMBER() OVER (order by T.OperDT desc)AS Row, T.* from Tb_OperLog T WHERE 1=1 ) TT WHERE TT.Row between 1 and 10
SELECT * FROM ( SELECT ROW_NUMBER() OVER (order by T.OperDT desc)AS Row, T.* from (select U_CNAME,TruckNO,OperDT from Tb_OperLog inner join SYS_USER on Tb_OperLog.USERID=SYS_USER.USERID) T WHERE 1=1 ) TT WHERE TT.Row between 1 and 10