SELECT ROWNUM AS RANK, last_name, salary
FROM (SELECT last_name, salary
FROM employees
ORDER BY salary DESC)
WHERE ROWNUM <= 5;
SELECT e1.RANK, e.NAME, e.dige, e.salary
FROM ha e,
(SELECT ROWNUM RANK, salary
FROM (SELECT DISTINCT salary
FROM ha
ORDER BY salary DESC)
WHERE ROWNUM <= 4) e1
WHERE e.salary = e1.salary
ORDER BY salary DESC
SELECT f.RANK, e.NAME, e.dige, e.salary
FROM ha e,
(SELECT ROWNUM RANK, salary
FROM (SELECT DISTINCT salary
FROM ha
ORDER BY salary DESC)
WHERE ROWNUM <= 4) f
WHERE e.salary = f.salary
ORDER BY salary DESC
Halim is a Sr. Database Engineer/Data Architect (in Atlanta, USA) who is an Oracle certified (OCP) DBA, (OCP) Developer, Certified Cloud Architect Professional as well as OCI Autonomous DB specialist with extensive expertise in Database design, configuration, tuning, capacity planning, RAC, DG, Scripting, Python, PL/SQL etc. He achieved 16th position in worldwide first-ever PL/SQL Challenge cup playoff- http://plsql-challenge.blogspot.com/2010/07/winners-of-first-plsql-challenge.html
Subscribe to:
Post Comments (Atom)
My Blog List
-
-
Index Usage – 21 week ago
-
-
-
-
-
-
-
-
Oracle Cloud & Third party tools3 years ago
-
-
-
Moving Sideways7 years ago
-
Upcoming Events...10 years ago
-
No comments:
Post a Comment