select salary from ( select salary, dense_rank() over(order by salary desc

how to find the second highest salary from emp table?

Question Posted / dev anand s

Answer Posted / dev anand s

select salary from (
select salary, dense_rank() over(order by salary desc) rank from emp) where rank=2;

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is a dynamic query?

1073

can a stored procedure call itself or recursive stored procedure? : Sql dba

1086

How to change sql*plus system settings?

1111

Is it possible to pass parameters to triggers?

1164

What are pl sql data types?

1056

How we can update the view?

1099

what are the advantages and disadvantages of views in a database? : Sql dba

1075

What is equi join in sql?

1119

Name three sql operations that perform a sort.

1066

Define overloaded procedure?

1133

How to avoid using cursors?

1179

Which table is left in left join?

1065

What is thread join () in threading?

1057

What are different types of tables in sql?

1052

What is user in sql?

1078