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

Define phantom deadlock.

531

What is mean by dbms?

494

Why do we need database?

499

What is the advantage of database management system?

416

What are database functions?

459

What is snow flake schema design in database? What's the difference between star and snow flake schema?

446

What are the types of database?

471

Enlist the various relationships of database.

618

What is natural key?

535

What is the maximum line size that dbms_output can handle?

554

Describe reporting lifecycle?

502

Operators used in select statements are?

487

What is tuple and attribute?

490

Write a query to remove duplicate rows from a table?

455

What is tabular form?

537