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

Which is the correct statement about truncate and delete?

1061

What is clustered index in sql?

1018

what is timestamp in mysql? : Sql dba

1033

What is a full join sql?

999

is mysql query is case sensitive? : Sql dba

1048

How many types of relationship are there?

998

what are local and global variables and their differences? : Sql dba

1034

what is csv? : Sql dba

959

What is pivot table in sql?

1046

What is primary key and unique key?

1079

How does a self join work?

1033

Is it possible to include an insert statement on the same table to which the trigger is assigned?

977

Why is normalization important?

988

what are date and time data types? : Sql dba

946

What is the sql*loader? : aql loader

1029