how to find the second highest salary from emp table?
- 211 Answers
- 321154 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 / rajkishore bagwan
simplest method ----
select salary
from employees
order by salary desc
offset n-1 rows fetch next 1 rows only
(replace n with any number it will give you the nth highest salary)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what are all different types of collation sensitivity? : Sql dba
Is it possible to create the following trigger: before or after update trigger for each row?
Can I join the same table twice?
Why stored procedures are faster than query?
what is meant by nl2br()? : Sql dba
mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql
how to start mysql server? : Sql dba
How to read/write files from pl/sql?
What is difference between primary and secondary key?
What is compiled query?
What is rtm in testing?
Is ms sql is free?
What is nosql example?
How do I start pl sql?
who introduced sql?
