About 10-20 Records in Oracle,sqlserver,mysql

One: Oracle database notation:

1:select * FROM (select RowNum RN, * from table name where?rownum<20?) a?

? where a.rn>10

2:select * FROM table name where rownum<20

Minus

SELECT * FROM table name where rownum<10

?

II: SQL Server database notation:

1:select Top * FROM tablename where ID not?exists (select top?10 * FROM tablename)//First 20 records filter out the first 10

2:select Top10 * FROM (select top to order by column) The ORDER BY column desc//subquery takes 20 reverse, and then takes the first 10 lines from the subquery

Three:MySQL 's wording:

SELECT * FROM tablename where LIMIT 9,10

About 10-20 Records in Oracle,sqlserver,mysql