Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 368599 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 / hari thorat
select max(salary) from employee where salary <(select max(salary) from employee);
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is primary and foreign key?
Should I use mbr or gpt?
Lookups are a key component in sql server integration services (ssis). Explain its purpose?
What is trigger in pl sql?
What are predefined functions in sql?
What are dml commands?
what is a stored procedure? : Sql dba
What are triggers and its types?
How many sql statements are used? Define them.
Define commit?
What is sql used for?
Is sql harder than python?
How insert into statements in sql?
How is data stored on a disk?
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
