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

Why are cursors used?

1119

what are the join types in tsql? : Transact sql

1064

Is inner join same as self join?

1111

What is row_number () in sql?

978

What are the two characteristics of a primary key?

970

Can we edit a view in sql?

983

What are the different parts of a package?

1113

is it possible to pass an object or table to a procedure as an argument?

1129

Can you do multiple joins in sql?

1048

What is trigger explain with example?

1033

What is the use of sql trace?

950

What are inbuilt functions in sql?

1054

How do I truncate a word?

1087

What is the use of pl/sql table?

1063

How can we avoid duplicating records in a query?

979