SQL笔记

1.选择第5到第10条数据，ID不连续

ORACLE:

SELECT *  FROM (SELECT a.*, ROWNUM rn FROM tablename a WHERE ROWNUM <= 10) WHERE rn >= 5

SQL:

(不包含第5数据记录，从第6条记录开始显示,如果需要包含第5条记录:SELECT TOP 4 user_no FROM tablename)

SELECT TOP 5 * FROM tablename WHERE USER_NO NOT IN (SELECT TOP 5 user_no FROM tablename)