Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 368589 Views
- CIS, Cognizant, Cosmosoft, DAS, EDS, GreenTech, HOV Services, IBM, Infosys, National Institute of Science and Technology, Patni, Persistent, Polaris, TCS, Wipro, Yardi, Zensar, I also Faced
- E-Mail Answers
Answer Posted / nirjesh pandey
select salary from employee order by salary DESC LIMIT(1,1)
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Can we use rowid as primary key?
Why self join is used in sql?
What is serial sql?
What is set serveroutput on?
How would you pass hints to the sql processor?
What are the uses of sysdate and user keywords?
What is the use of sqlerrd 3?
What are different clauses used in sql?
Can you do multiple joins in sql?
How does index help in query performance?
What is sql in oracle?
What is delete command in sql?
How bulk collect improves performance?
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 is pragma in sql?
