mysql sqlserver 类似oracle rownum

9.sqlserver rownum

With TTTTT AS(select * from USERS t)

SELECT * from (select ROW_NUMBER() OVER(ORDER BY userid DESC) AS rn,* from TTTTT)

 as T where rn between 1 and 10

 

10 mysql rownum

select * from esb_process_data as C where C.id in (select p.* from (select A.id from esb_process_data as A order by A.id limit "+end+") as p)and C.id not in(select q.* from (select B.id from esb_process_data as B order by B.id limit "+start+") as q)