SQL> select max(sal) from emp where rownum<=(select count(sal)-1 fro

how to find the second highest salary from emp table?

Question Posted / raghu munukutla

Answer Posted / raghu munukutla

SQL> select max(sal) from emp where rownum<=(select
count(sal)-1 from emp)
order by sal desc;

Is This Answer Correct ?

3 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How does postgresql compare to oracle/db2/ms sql server/informix?

1094

Does access use sql?

1101

what is table? : Sql dba

1109

What are %type and %rowtype for?

1109

what are sequences

1824

How many clustered indexes can you have?

1038

Show how functions and procedures are called in a pl/sql block.

1188

How do I truncate a sql log file?

1138

How do you bind variables in pl sql?

1160

What is denormalization in a database?

1107

How can a function retun more than one value in oracle with proper example?

1129

Can we create table inside stored procedure?

1016

Can we call stored procedure in function?

1004

What is rank function in sql?

1072

What are the different sql languages?

1093