how to retrieve the top 3 salaries of the table using rownum
Answer Posted / nitesh
select sal from emp e where 3>=(select count(distinct sal)
from emp where sal>e.sal) order by sal desc;
Is This Answer Correct ? | 5 Yes | 3 No |
Post New Answer View All Answers
Explain polymorphism in pl/sql.
what are rollup and cube in t-sql? : Transact sql
How do I audit the sql sent to the server?
What is error ora-01000: maximum open cursors exceeded
Why schema is used in sql?
Does db2 use sql?
which operator is used in query for pattern matching? : Sql dba
Whis is not false in primary key?
How many columns should be in an index?
Does sql full backup truncate logs?
How do you write an index?
How can we optimize a sql query?
What is difference sql and mysql?
1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins
What is oracle sql developer?