Interested to Buy Any Domain ? << Click Here >> for more details...
i need department wise top 2 employees salary.which logic
i will use
- 17 Answers
- 32220 Views
- I also Faced
- E-Mail Answers
Answer Posted / ramya p
Select * from emp where sal in
(Select * From (Select sal from emp order by sal desc)
Where rownum < 3) order by sal desc;
| Is This Answer Correct ? | 6 Yes | 18 No |
Post New Answer View All Answers
how to use in conditions? : Sql dba
What is the difference between null value, zero, and blank space?
How many types of relationship are there?
What is varchar used for?
What problem one might face while writing log information to a data-base table in pl/sql?
what is a relationship and what are they? : Sql dba
Do we need to rebuild index after truncate?
what is blob? : 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
What are the different types of joins in sql?
What are records give examples?
what are date and time functions in mysql? : Sql dba
How consistent is the view of the data between and within multiple sessions, transactions or statements ?
What is the reports view in oracle sql developer?
What does <> sql mean?
