Oracle+.Net / oracle分页sql

SELECT * FROM (SELECT A.*, ROWNUM RN FROM (SELECT * FROM TableName   Order by ID asc ) A WHERE ROWNUM <= 10)WHERE RN > 0