2类order by;
1,单纯的 order by;
2,union 中的 order by;
SQL> SELECT 2 col1,'a' col2 FROM dual
2 UNION
3 SELECT 1,'x' FROM dual
4 UNION
5 SELECT 3,'z' FROM dual
6 ORDER BY 3; // 这个“3” 表示的是以第三列排序,但是没有第三例,所以报错了。
ORDER BY 3
*
第 6 行出现错误:
ORA-01785: ORDER BY 项必须是 SELECT-list 表达式的数目
SQL> SELECT 2 col1,'a' col2 FROM dual
2 UNION
3 SELECT 1,'b' FROM dual
4 UNION
5 SELECT 3,'z' FROM dual
6 ORDER BY 1;
COL1 C
---------- -
1 b
2 a
3 z
SQL> SELECT 2 col1,'a' col2 FROM dual
2 UNION
3 SELECT 1,'b' FROM dual
4 UNION
5 SELECT 3,'z' FROM dual
6 ORDER BY 2;
COL1 C
---------- -
2 a
1 b
3 z