how to retrieve the top 3 salaries of the table using rownum
Answer Posted / kalyan kumar
select e.ename,e.sal from emp e where 3>(select count
(distinct(b.sal)) from emp b where b.sal>e.sal)
Is This Answer Correct ? | 19 Yes | 10 No |
Post New Answer View All Answers
Does inner join remove duplicates?
What is pl sql in oracle?
What are the main features of cursor?
How do you know if a relationship is 2nf?
What do you know by pl/sql cursors?
What does the file extension accdb stand for?
Write a sql query to get the third highest salary of an employee from employee_table?
What is crud sql?
What is union?
What is pl sql architecture?
What does count (*) mean in sql?
what are the types of subquery? : Sql dba
What are the rules to be applied to nulls whilst doing comparisons?
What is duration in sql profiler trace?
Can we alter stored procedure?