项目 | 字符范围 |
---|---|
字母(语法不区分大小写) | A-Z |
数字 | 0-9 |
字符 | + - * = ? ! @ ( ) _ . , < > | |
特别不推荐的字符 | $ # |
SELECT [column_list], ROWNUM
FROM ( SELECT [column_list] FROM table ORDER BY column ) WHERE ROWNUM <= n; |
with dt as ( select 'b' as tc from dual union select 'a' as tc from dual union select 'd' as tc from dual union select 'c' as tc from dual union select 'e' as tc from dual union select 'f' as tc from dual union select 'g' as tc from dual union select 'h' as tc from dual order by 1 ) select t2.* from ( select dt.*,rownum rn from dt ) t2 where rn>2 and rn<=4 order by rownum |