how to retrieve the top 3 salaries of the table using rownum
- 31 Answers
- 36929 Views
- Oracle, I also Faced
- E-Mail Answers
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
What are different types of sql commands?
What is the use of sql trace?
What is flag in sql?
Explain constraints in sql?
Can we use ddl statements in stored procedure sql server?
What is database white box testing and black box testing?
What does inner join mean?
Name some usages of database trigger?
Is sqlexception checked or unchecked?
What is trigger with example?
What is the reports view in oracle sql developer?
Is sql a dbms?
Can I join the same table twice?
Does pl/sql support create command?
What is trigger explain with example?
