Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 373182 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 are the types of triggers in sql?
How do you bind variables in pl sql?
Can I join the same table twice?
What is the usage of when clause in trigger?
How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000
Can we use having without group by in sql?
Which column of the user triggers data dictionary view displays the database event that will fire the trigger?
What is the sql case statement?
Is hadoop a nosql?
Mention what is the plv (pl/vision) package offers?
What is pl sql code?
Which query operators in sql is used for pattern matching?
Can we join same table in sql?
What does select * from mean in sql?
Does pl sql work in mysql?
