select vu.sal from (select DENSE_RANK() over(order by sal desc) as sr,

find the third highest salary?

Question Posted / farrukh shaikh

Answer Posted / farrukh shaikh

select vu.sal from
(select DENSE_RANK() over(order by sal desc) as sr,
sal from emp) vu
where vu.sr=3

Is This Answer Correct ?

3 Yes

3 No

Please Help Members By Posting Answers For Below Questions

Can primary key be changed?

871

Why is a trigger used?

890

What is a design view?

887

Explain the the update statement in sql?

990

What is use of term?

1009

What is keys and its types?

1022

How do you delete data from a table?

976

What is union?

1085

What is procedure explain with program?

952

how to convert dates to character strings? : Sql dba

1073

What is the life of an sql statement?

964

What is a native sql query?

977

Is pl sql useful?

934

What is right join in sql?

1024

Is primary key clustered or nonclustered?

954