Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 373224 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 / hima
select sal from emp order by salary desc limit 1,1
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How do I start sql profiler?
Can sql function call stored procedure?
Explain the rollback statement?
What is bulk collect in pl sql?
How do I edit a stored procedure?
How do I get sql certification?
How to use distinct and count in sql query? Explain
What are instead of triggers?
What is pl sql quora?
What are hotfixes and patches?
what is msql? : Sql dba
what is sub-query? : Transact sql
What is form and report?
Explain the select statement in 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
