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 is a mutating table and a constraining table?

1120

Are sql database names case sensitive?

1009

What is the max nvarchar size?

985

How to avoid using cursors?

1128

Which is better trigger or stored procedure?

955

What is using in sql?

1098

what happens if you no create privilege in a database? : Sql dba

1007

what is a control file ? : Sql dba

1045

How do you pronounce sql?

1020

Do triggers have restrictions on the usage of large datatypes, such as long and long raw?

1171

How do you write a subquery?

1033

What is a clob in sql?

1026

How does pl sql work?

967

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

1083

how to create a new view in mysql? : Sql dba

942