how to find the second highest salary from emp table?
- 211 Answers
- 322072 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 / vikas
select top 1 salary from emp
where salary in (select top 2 salary from emp order by salary desc)order by salary
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the benefits of triggers?
Explian rowid, rownum? What are the psoducolumns we have?
What do you mean by stored procedures? How do we use it?
Difference between global and parameter variables?
What is the purpose of cursors in pl/sql?
What are the commands used in sql?
What is asqueryable?
What are sql ddl commands?
How many disk partitions should I have?
Why are cursors used?
Can a table contain multiple primary key’s?
what is sub-query? : Transact sql
What are different functions in sql?
What is query syntax?
What are the two different parts of the pl/sql packages?
