select sal from (select sal,rank() over(order by sal desc) as rank from em

how to get second highest salary in SQL(as/4000

Question Posted / devi

Answer Posted / devi

select sal from (select sal,rank() over(order by sal desc)
as rank from emp) where rank>1 and rank<3

Is This Answer Correct ?

4 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What are the benefits of triggers?

1165

what are the type of locks ? : Sql dba

958

What are triggers and its types?

1055

What is on delete restrict?

998

Can pl sql procedure have a return statement?

1023

What is identity column in sql server?

1041

How do you delete a table?

1067

What is the need of a partition key?

981

What do you mean by stored procedures?

1008

what is the difference between sql and t-sql? : Transact sql

1084

What is AUTH_ID and AUTH_USER in pl/sql ?

2182

What are sql*plus environment variables?

1093

How to find 3rd highest salary of an employee from the employee table in sql?

1079

What is form and report?

972

What is asqueryable?

961