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

What is relationship? How many types of relationship are there?

1263

List the ways to get the count of records in a table?

942

What is the difference between explicit and implicit cursors in oracle?

1115

Is join an inner join?

1025

What are the different datatypes available in PL/SQL?

1147

Why indexing is needed?

1045

Can we insert data into view?

950

What are the uses of merge?

1225

What is on delete set null?

1135

What is a sql statement?

1018

what are the properties and different types of sub-queries? : Sql dba

1075

How many types of cursors supported in pl/sql?

1258

what are myisam tables? : Sql dba

1077

How do I order columns in sql?

1073

Can you have more than one key in a database?

993