SELECT * FROM TABLEA E1 WHERE N = (SELECT COUNT(DISTINCT (E2.SAL)) FROM TABLEA E2
SELECT DISTINCT (a.sal) FROM EMP A WHERE &N = (SELECT COUNT (DISTINCT (b.sal)) FROM EMP B WHERE a.sal < = b.sal) WHERE E2.SAL >= E1.SAL)
Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!