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

What is pl/sql table? Why is it used?

1094

What are the advantages of pl sql over sql?

1078

What is difference between sql and oracle?

1192

what are the type of locks ? : Sql dba

1010

Can we use delete in merge statement?

1101

what is clause? : Sql dba

1118

What does partition by mean in sql?

1032

What is the purpose of the partition table?

1089

What is the difference between left and left outer join?

994

What is rownum and rowid?

1077

What are different types of keys?

1176

Is sql injection illegal?

1082

What is a design view?

978

What does trigger mean in slang?

1126

What is data control language?

1034