Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 367648 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 is the difference between syntax error and runtime error?
What does the hierarchical profiler does?
How long it takes to learn pl sql?
how to create a table index in mysql? : Sql dba
What is a dynamic query?
Are pl sql variables case sensitive?
What is a parameter query?
Is coalesce faster than isnull?
What are pl/sql cursor exceptions?
how to check myisam tables for errors? : Sql dba
What is the difference between delete and truncate commands?
What is clustered index in sql?
What is flag in sql?
What is graph sql?
What is difference between procedure and trigger?
