Oracle、Sql Server、Mysql分页

Oracle:
SELECT * FROM  
(  
SELECT A.*, ROWNUM RN  
FROM (SELECT * FROM TABLE_NAME) A  
WHERE ROWNUM <= 10 
)  
WHERE RN >= 1  
Sql Server:
SELECT * FROM
(
SELECT A.*, COUNT (1) OVER () AS [rowCount],row_number () OVER (ORDER BY A.Dates DESC) AS rowNum
FROM TABLE_NAME A
) p
WHERE
p.rowNum > 0
AND p.rowNum <= 10
ORDER BY
p.Datess DESC
Mysql:
SELECT A.* FROM TABLE_NAME A limit  0,10