SELECT * FROM EMP WHERE N=(SELECT COUNT(DISTINCT SAL) FROM EMP WHERE SAL&g

select Nth highest salary by using rownum

Question Posted / xxx

Answer Posted / xxx

SELECT * FROM EMP WHERE N=(SELECT COUNT(DISTINCT SAL) FROM EMP
WHERE SAL>=e.SAL);

Is This Answer Correct ?

3 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is the default '-sort' order for a sql?

901

What is openedge translation manager?

1077

What are the benefits of modeling?

1084

What are the database objects?

1056

Explain fully functional dependency?

968

What is the biggest advantage of rdbms?

1049

Explain data dictionary.

910

Is there a way to detect whether fbclient.dll or fbembed.dll is loaded?

917

What are different types of transaction isolation levels?

1011

Have you written applications to retrieve stored images in a table?

1021

Why do we study dbms?

945

What are the two types of indexes and explain them in detail?

935

What is dbms introduction?

949

What is dbms used for?

1007

What is alternate key?

925