Oracle, server, and my SQL syntax differences

1. Summarize the syntax for querying 10-20 Records in Oracle, SQL Server, and MySQL

One: Oracle database notation:

1:select * FROM (select RowNum RN, * from table name wher 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 ten * 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

Oracle, server, and my SQL syntax differences