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 are the basic sql commands?

551

What is the use of count (*) in sql?

551

What is a record in pl/sql?

551

Which software is used for pl sql programming?

526

What are sql functions? Describe the different types of sql functions?

563

how to delete an existing column in a table? : Sql dba

555

What are the types of operators available in sql?

554

what is the difference between clustered and non clustered index in sql? : Sql dba

553

How do I access sql anywhere database?

501

What are the different types of constraints?

566

How delete all records from table in sql?

556

How to use boolean type in select statement?

585

Explain what is a database?

652

What is a field in a database?

572

What is execute immediate?

550