find out the second highest salary?
- 55 Answers
- 81399 Views
- Cognizant, Nucsoft, Oracle, TCS, Wondersoft, I also Faced
- E-Mail Answers
Answer Posted / janmejaya
select top(1) * from employee where salary in (select
distinct top(2) salary from employee order by salary desc)
order by Salary
Above query is dynamic, if u want 3rd highest then just
change 2 to 3 , Please Try It
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What is the order of defining local variables and sub procedures/functions?
What is bulk load in oracle?
How do I know if oracle is installed on windows?
How to use windows user to connect to the server?
What are temporal data types in oracle?
Differentiate between function and procedure in oracle.
How to delete all rows a table in oracle?
What is a initialization parameter file in oracle?
How to create an oracle database manually?
How to export your connection information to a file?
does the query needs a hint to access a materialized view?
What is a dead lock in oracle?
Please explain oracle data types with examples?
What is a view and how is it different from a table?
How to create an oracle database?
