how to find the second highest salary from emp table?
- 211 Answers
- 320682 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 / erp_guns
SELECT MAX(sal) from emp a where &n=(select COUNT(DISTINCT
(SAL)) from emp b where a.sal<=b.sal)
| Is This Answer Correct ? | 39 Yes | 22 No |
Post New Answer View All Answers
Is sql procedural language?
Why use truncate instead of delete?
What is the use of triggers?
What normalization means?
Define join and name different types of joins?
How to fetch alternate records from a table?
Explain cursor types?
Is coalesce faster than isnull?
Compare sql & pl/sql
How do you drop a trigger?
What is sql and how does it work?
What does plv msg allows you to do?
What is the usage of sql functions?
What is secondary key?
The in operator may be used if you know the exact value you want to return for at least one of the columns.
