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 coalesce sql?

939

what are all types of user defined functions? : Sql dba

996

how to create a table index in mysql? : Sql dba

986

How do you update f as m and m as f from the below table testtable?

1789

What is rownum in sql?

965

Which is better varchar or nvarchar?

933

What are the types of join in sql?

1027

What are the set operators in sql?

1028

What is raid? How does it help storage of databases?

1032

What is pragma in pl sql?

1020

Does truncate table reset auto increment?

939

What is compilation error in pl sql?

920

Is there a way to automate sql execution from the command-line, batch job or shell script?

918

What is difference between sql and excel?

1006

Explain alias in sql?

994