how to find the second highest salary from emp table?
- 211 Answers
- 321036 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 / kishor
select max(salary ) from employee
where
sal<(select max(salary)from employee)
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Why we use stored procedure instead of query?
What is server name sql?
What is the difference between join and natural join?
What is faster join or subquery?
How can you load microsoft excel data into oracle? : aql loader
Can procedure in package be overloaded?
what are the authentication modes in sql server? : Sql dba
How subquery works in sql?
How many joins in sql?
what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba
What is sql partition function?
Mention what does plv msg allows you to do?
what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba
Explain constraints in sql?
Can we rollback delete command?
