| 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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
