how to find the second highest salary from emp table?
- 211 Answers
- 321295 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 / muhammed zaheer
select max(sal) from emp where sal < (select max(sal) from
emp)
| Is This Answer Correct ? | 86 Yes | 16 No |
Post New Answer View All Answers
What is sql deadlock?
how to check myisam tables for errors? : Sql dba
How is pl sql different from sql?
What is the most restrictive isolation level? : Transact sql
Can a view be mutating? If yes, then how?
Which join is like an inner join?
When can we use the where clause and the having clause?
What is rownum in sql?
what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba
explain advantages of myisam over innodb? : Sql dba
Why is sharding used?
what is a foreign key ? : Sql dba
Why schema is used in sql?
How many sql databases can you have on one server?
Is sqlite thread safe?
