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
What are the possible values for the boolean data field?
How can you load microsoft excel data into oracle? : aql loader
What are the benefits of pl sql?
what is a relationship and what are they? : Sql dba
Are there any features that are decommissioned in 11g that are not present in 11g?
Can we enter data in a table in design view?
what is a tablespace? : Sql dba
When sql appeared?
Describe different types of general function used in sql?
How does stored procedure reduce network traffic?
Mention what is the plv (pl/vision) package offers?
Explain constraints in sql?
Explain the select statement in sql?
What is synchronized subquery?
how to create a new table in mysql? : Sql dba