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
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