SELECT * FROM HR.EMPLOYEES EMP1 WHERE &N=( SELECT COUNT(DI

select Nth highest salary by using rownum

Question Posted / welcomeashwin

Answer Posted / welcomeashwin

SELECT * FROM HR.EMPLOYEES EMP1
WHERE &N=(
SELECT COUNT(DISTINCT(SALARY))
FROM HR.EMPLOYEES EMP2
WHERE EMP1.SALARY<=EMP2.SALARY
);

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How do you delete a table from database?

985

Can you have more than one cursor open at any one time in a program ?

957

What are the database objects?

1052

What is the relationship?

977

Difference between data and information, and how are they related in a database?

972

Explain the functionality of dml compiler.

1001

What are five types of database models?

888

What is cold backup, hot backup, warm backup recovery?

829

What is the purpose of a field in a database?

963

What are the basic functions of a database?

1030

What are the features of dbms?

944

How can you get the alternate records from the table in the sql?

943

How to export data from database and import into another?

915

What is limit in dbms?

1044

Explain the classification of Database Management System?

4204