Hi Everyone,
Trying below CTE but its giving error as “ORA-00928: missing SELECT keyword”
WITH my_cte AS
(SELECT sal, DENSE_RANK() OVER (ORDER BY sal DESC) AS denserank FROM scott.emp);
SELECT * FROM my_cte WHERE denserank = 3;
I cant see anything wrong, but it doesnt seem to work. Any suggestion or anything wrong im doing here. Please let me know.