Interested to Buy Any Domain ? << Click Here >> for more details...
how to get second highest salary in SQL(as/4000
- 29 Answers
- 32129 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
What are types of exception?
What is pl/sql table? Why it is used?
What is a variable in sql?
How do I create a sql script?
What is having clause in sql?
explain what is mysql? : Sql dba
What is varchar data type in sql?
How global cursor can be declare with dynamic trigger ?
Can we insert data in view?
How we can update the view?
How do I remove sql plus from windows 10?
Cite the differences between execution of triggers and stored procedures?
what are the differences among rownum, rank and dense_rank? : Sql dba
What is using in sql?
What is the purpose of the sql select top clause?
