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

Answer Posted / swapnareddy

select sal from emp a where 3>(select
count(distinct(sal))from emp b where a.sal<b.sal);

Is This Answer Correct ?    4 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the possible values for the boolean data field?

686


How can you load microsoft excel data into oracle? : aql loader

808


What are the benefits of pl sql?

763


what is a relationship and what are they? : Sql dba

741


Are there any features that are decommissioned in 11g that are not present in 11g?

1819






Can we enter data in a table in design view?

707


what is a tablespace? : Sql dba

760


When sql appeared?

814


Describe different types of general function used in sql?

724


How does stored procedure reduce network traffic?

730


Mention what is the plv (pl/vision) package offers?

837


Explain constraints in sql?

766


Explain the select statement in sql?

819


What is synchronized subquery?

817


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

710