select name,salary from (select salary from emp order by salary desc)where

how to find the second highest salary from emp table?

Question Posted / mastan

Answer Posted / mastan

select name,salary from (select salary from emp order by
salary desc)where rownum<2

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Can you do multiple joins in sql?

1062

How do I partition a table in sql?

1143

How do I trace sql profiler?

998

What is sql indexing?

1019

Do prepared statements prevent sql injection?

957

Which join is like an inner join?

1036

What is meant by truncate in sql?

1074

What is dml with example?

1096

How to process query result in pl/sql?

1143

Can we commit in trigger?

987

What are all the different normalization?

1049

How to start the command-line sql*plus?

1063

Can we use ddl statements in stored procedure?

1162

What are different joins used in sql?

1067

Why commit is not used in triggers?

1049