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

Answer Posted / raghunanda

SELECT * FROM(SELECT * FROM EMP ORDER BY SAL DESC) WHERE ROWNUM<=3;

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the different sql languages?

740


Is ms sql traffic encrypted?

685


What do you think about pl/sql?

701


What is left join example?

677


What is the size of partition table?

742






How would you reference column values before and after you have inserted and deleted triggers?

818


What is coalesce sql?

700


How do I create a sql script?

761


Explain raise_application_error.

830


How do you copy a table in sql?

753


What is database sql?

709


what are different types of collation sensitivity? : Sql dba

757


Can a table contain multiple foreign key’s?

743


how to select unique records from a table? : Sql dba

825


Can a composite key be null?

713