EMP表,主键impId,查询第10条到第20条数据。
SqlServer:select top 10 * from EMP where empid not in (select top 10 from EMP)
MySql: select * from EMP limit 10,10
Oracle: select * from (select rownum r,t.* from EMP t where rownum<=20) where r>10
SqlServer:select top 10 * from EMP where empid not in (select top 10 from EMP)
MySql: select * from EMP limit 10,10
Oracle: select * from (select rownum r,t.* from EMP t where rownum<=20) where r>10