Which way is faster? The subselect(nested select) or the join? Thanks.
-- Lyndon Tiu Quoting Jacques Kilchoer <[EMAIL PROTECTED]>: > Why would you do that instead of > SELECT emp.deptno, empno, ename > FROM emp a, dept b > WHERE dept.deptno = emp.deptno > order by dept.deptname ; > > > -----Original Message----- > > From: Nicoll, Iain [mailto:[EMAIL PROTECTED] > > > > Don't really know but couldn't it be useful if you had > > > > ORDER BY ( SELECT deptname FROM dept > > WHERE dept.deptno = emp.deptno) > > > > > > -----Original Message----- > > From: Ashish [mailto:[EMAIL PROTECTED] > > > > In Oracle 9.2.0.1, you can now order by using a single-row > subquery > > Here is an example: > > > > SELECT emp.deptno, empno, ename > > FROM emp > > ORDER BY ( SELECT deptno FROM dept > > WHERE dept.deptno = emp.deptno ); > > > > The question I have is what is the usefulness of this? Under > which > > circumstances > > this can be used? > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Lyndon Tiu INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).