select salary from (select salary,Dense_RANK() over (Order by salary desc

how to find the second highest salary from emp table?

Question Posted / mohamed hussain

Answer Posted / mohamed hussain

select salary from
(select salary,Dense_RANK() over (Order by salary desc) as
Level from salary) TMP
where Level=@Level

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Explain isolation levels. : Transact sql

1072

What are tuples in sql?

1136

Can a commit statement be executed as part of a trigger?

1051

Why do we need databases?

1048

What is substitution variable?

1053

What are two statement types in sql?

1108

What is the syntax to add a record to a table?

1090

Are sql database names case sensitive?

1006

Is clustered index a primary key?

949

What is error ora-01000: maximum open cursors exceeded

1147

Explain exception handling in pl/sql?

1038

What is pivot in sql?

916

What is substitution variable in pl sql?

1046

What are % type and % rowtype?

1031

how to calculate the difference between two dates? : Sql dba

1063