| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> comp.databases.theory -> SQL: UNION ALL and ORDER BY
I have an SQL QUERY containing a number of SELECT FROM WHERE's joined by UNION ALL statements. Following the last statement is a single ORDER BY clause.
On my system the ORDER BY affects the order of all the results from the preceding SELECTs.
As I may wish to port this to other databases, is the feature described above standard SQL or specific to my implementation? Received on Tue Jul 10 2001 - 16:46:14 CDT
 |
 |