how to find the second highest salary from emp table?
- 211 Answers
- 322027 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 / manoj
select * from emp
where
sal=(select MAX(sal) from emp
where
sal<(select MAX(sal)from emp))
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is sql engine in oracle?
how to use myisamchk to check or repair myisam tables? : Sql dba
how to create a table index in mysql? : Sql dba
What are the different types of dbmss?
How do I view a procedure in sql?
What is procedure explain with program?
What is mutating table error?
What is the difference between delete and truncate statement in sql?
What is left inner join in sql?
What is mutating error in pl sql?
how tsql statements can be written and submitted to the database engine? : Transact sql
What are its different types of dbms?
What is not equal in sql?
How do you concatenate in sql?
Is postgresql a server?
