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

Enlist various transaction phases.

940

How to select a random record from a table?

890

What is a form used for in a database?

865

What is a database management system and give examples?

878

What is difference between database and schema?

929

What is the use case where we can use stretch database?

878

How many types of database languages are?

887

Which database is used by google?

927

What are the various kinds of interactions catered by dbms?

2065

What is create database?

905

How do you rename a database?

844

What is the maximum size of an access database?

801

Should database table names be capitalized?

931

Explain all codd's rules for relational database system?

885

What is a candidate key in a database?

835