how to find the second highest salary from emp table?
- 211 Answers
- 322093 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 / naveen r kumar
SELECT Max(salary) FROM TABLE
WHERE salary NOT IN (SELECT Max(salary) FROM TABLE);
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is a subquery in sql?
What is a database? Explain
How many types of indexes are there in sql?
What is procedure and function in sql?
What is hibernate and its relation to sql?
What is dynamic query?
Why plvtab is considered as the easiest way to access the pl/sql table?
Will truncate release space?
what are different types of keys in sql?
list out some tools through which we can draw e-r diagrams for mysql. : Sql dba
What is sqlerrd?
What is database sql?
How to use transactions efficiently : transact sql
Is sql considered coding?
What is difference between sql and mysql?
