how to get second highest salary in SQL(as/4000
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 to display Row Number with Records in Oracle SQL Plus?
What is pl sql block in dbms?
What is assignment operator in pl sql?
Write a query to display the current date in sql?
What are the limitations of sql express?
what are enums used for in mysql? : Sql dba
What does select count (*) mean in sql?
What is sql deadlock?
List the different type of joins?
What is a behavioral trigger?
How can you fetch common records from two tables?
Explain 3 basic parts of a trigger.
Can primary key be changed?
What type of database is cloud sql?
What is the source code of a program?