Home » RDBMS Server » Networking and Gateways » Subselect in select clause
Subselect in select clause [message #367620] Fri, 09 April 1999 00:44
Mark Banks
Messages: 1
Registered: April 1999
Junior Member
This works fine in SQL Server:

SELECT RANK, TITLE_ID, YTD_SALES, TITLE
FROM (SELECT
T1.TITLE_ID,
YTD_SALES,
T1.TITLE,
( SELECT COUNT(YTD_SALES)
FROM TITLES AS T2
WHERE T1.YTD_SALES <= T2.YTD_SALES)
AS RANK
FROM TITLES AS T1) AS X
WHERE YTD_SALES IS NOT NULL
ORDER BY RANK

But ORACLE 8 cannot execute it.

Any suggestions? Can someone enlighten me on subquery expressions within the SELECT clause under Oracle?!

Regards

Mark Banks.
Previous Topic: Net*8 version problem (or just kidding?)
Next Topic: DBLink Timeout
Goto Forum:
  


Current Time: Wed Feb 21 10:11:16 CST 2024