Write a query to get 2nd maximum salary in an employee table ?
Answer Posted / paddu
Mr. Ebnezer this is not a comedy site, to do the comedy.You
know the answer, post it.otherwise leave it.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
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
Does sql require a server?
What is not equal in sql?
What is the difference between the sql*loader and import utilities? : aql loader
Can we rollback delete command?
What is a unique key?
Explain how exception handling is done in advance pl/sql?
How does one load ebcdic data? : aql loader
Can we create clustered index without primary key?
What language is oracle sql developer?
Is not equal in sql?
What are the benefits of triggers?
Can dml statements be used in pl/sql?
What is the difference between partitioning and sharding?
What is the use of %rowtype?