Interested to Buy Any Domain ? << Click Here >> for more details...
how to get second highest salary in SQL(as/4000
- 29 Answers
- 32264 Views
- iGate, I also Faced
- E-Mail Answers
Answer Posted / santosh kumar
select employee_id,last_name,salary
from
(select rownum r,employee_id,last_name,salary
from (select employee_id,last_name,salary from employees
order by salary desc)) a
where a.r=&nth_salary;
---u can find nth highest salary----
for more detail u can contact me at
rajgupta7666@gmail.com....
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How do I run a script in sql developer?
Is coalesce faster than isnull?
What is blind sql injection?
Is pl sql different from sql?
What is a natural join sql?
What is the use of desc in sql?
What are different methods to trace the pl/sql code?
Why having clause is used in sql?
What is difference between sql and excel?
How do I save the results of sql query in a file?
What is the difference between having clause and where clause?
How to connect a sql*plus session to an oracle server?
what are the different type of normalization? : Sql dba
What is coalesce in sql?
What are dml commands?
