Subquery in Order By Clause [message #371328] |
Wed, 04 October 2000 03:54 |
Venkatramanan
Messages: 10 Registered: October 2000
|
Junior Member |
|
|
Consider the following query :
#1 SELECT ENAME,SAL FROM EMP ORDER BY 1;
It is properly working.
But when I give like this,
#2 SELECT ENAME,SAL FROM EMP ORDER BY (SELECT 1 FROM DUAL)
1. It is not reporting any error.
2. It is not properly ordering the result.
Now, when I give like this,
#3 SELECT ENAME,SAL FROM EMP ORDER BY (SELECT ENAME FROM DUAL);
This time, it is properly ordering by ename.
When I give like this,
#4 SELECT ENAME,SAL FROM EMP ORDER BY (SELECT SAL FROM DUAL);
This time, it is properly ordering by SAL.
My questions are :
1. Can we use subquery in Order by clause ?
2. How subqueries in #3 and #4 are working ?
Please give me solutions.
Venkatramanan.
|
|
|