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

Which two can be implemented as a centrally located logical architecture?

964

What is database or database management systems (dbms)? And what's the difference between file and database? Can files qualify as a database?

974

What are its two major subsystems of r?

1221

Do models have limitations?

942

What are the applications of database management system?

953

describe and contrast a trigger and a procedure.

1102

What is unique key in dbms?

961

What are the five steps of data modeling?

1058

What is table normalization?

987

What is advantage of dbms?

1062

What are the characteristics of database management system?

1057

Why do we need database management?

1018

What are the advantages of dbms?

1000

Where is data stored in a database?

1064

What do you understand by data model?

1152