Interested to Buy Any Domain ? << Click Here >> for more details...
How to get employee name from employee table which is the
fiveth highest salary of the table
- 20 Answers
- 29477 Views
- Infosys, Rolta, I also Faced
- E-Mail Answers
Answer Posted / anil alpati
SELECT employee_name FROM employee order by salary desc limit 1 offset 5 ;
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What are the different parts of a package?
What is the difference between partitioning and sharding?
Sql technical questions
Does user triggers have entry for trigger with compilation errors?
What are the basic techniques of indexing?
What are the packages in pl sql?
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 does plv msg allows you to do?
Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?
Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?
What is break?
What does inner join mean?
Explain locks? : Transact sql
What are pl sql procedures?
How does index help in query performance?
