how to retrieve the top 3 salaries of the table using rownum
- 31 Answers
- 36931 Views
- Oracle, I also Faced
- E-Mail Answers
Answer Posted / akki julak
select sal from (select rownum,sal from emp order by sal
desc)
where rownum<4;
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is restrict in sql?
What are the benefits of pl sql?
Are sql database names case sensitive?
What is set transaction?
Why do we need databases?
How do you pronounce sql?
How do you write a subquery?
What is the difference between truncate and drop statements?
What is a behavioral trigger?
what is innodb? : Sql dba
how to delete duplicate rows from a join tables(I have three tables on that join) how do you know which join is need to be used? The select statement I have is: SELECT gc_skill_type.skill_type, gc_area_tec.area, gc_technology.technology, gc_technology.id_technology, gc_area_tec.id_area_tec FROM gc_skill_type, gc_area_tec, gc_technology WHERE gc_area_tec.id_skill_type (+) = gc_skill_type.id_skill_type AND gc_technology.id_area_tec (+) = gc_area_tec.id_area_tec order by gc_skill_type.skill_type asc, gc_area_tec.area asc, gc_technology.technology asc
How do I access sql anywhere database?
What is on delete set null?
What are all the common sql functions?
Explain locks? : Transact sql
