SELECT * FROM EMP A WHERE 1=(SELECT COUNT (*) FROM EMP B WHERE B.SAL>

how to retrieve the top 3 salaries of the table using rownum

Question Posted / nasir iqbal

Answer Posted / nasir iqbal

SELECT * FROM EMP A WHERE 1=(SELECT COUNT (*) FROM EMP B
WHERE B.SAL>=A.SAL)
SELECT * FROM EMP

Is This Answer Correct ?

1 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is materialized view in sql?

651

How many types of index are there?

724

Is sql developer case sensitive?

724

What are the advantages of pl sql over sql?

733

How do you remove duplicates without using distinct in sql?

695

What is cursor in pl sql?

767

What is Materialized View? In What Scenario we Use Materialized View?

8939

How do you drop a trigger?

711

What is the current version of sql?

734

What are the three forms of normalization?

758

What language is oracle sql developer?

714

What is the purpose of the sql select top clause?

738

How do you get column names only for a table (sql server)?

859

What is the main difference between sql and pl/sql?

757

How do you clear the screen in sql?

782