SELECT ROW_NUMBER() OVER (ORDER BY EMPID ASC) AS ROWID, * FROM EMPLOYEE
select * from (select row_number() over(order by Class) as 'myid',* from studb) mytb where mytb.myid>2 and mytb.myid<5
SELECT ROW_NUMBER() OVER (ORDER BY EMPID ASC) AS ROWID, * FROM EMPLOYEE
select * from (select row_number() over(order by Class) as 'myid',* from studb) mytb where mytb.myid>2 and mytb.myid<5
转载于:https://www.cnblogs.com/johnsmith/archive/2011/09/05/2167619.html