select * from emp where sal = (select max(sal) from emp where sal<>(s

how to find out second largest value in the table

Question Posted / anandh

Answer Posted / anandh

select * from emp where sal = (select max(sal) from emp where sal<>(select max(sal) from emp));

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is system tablespace?

1042

1) Does oracle have any table which contain all the exceptions and it's code internally?

1696

Explain the difference between sql and oracle?

1023

How to define an external table with a text file?

1019

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1877

How to create a new view in oracle?

1013

What will be the syntax to find current date and time in format "yyyy-mm-dd"?

967

How to pass a parameter to a cursor in oracle?

1103

What privilege is needed for a user to create tables in oracle?

901

How to connect to oracle using service name instead of sid?

963

Can we call procedure inside function in oracle?

1018

What are the ways tablespaces can be managed and how do they differ?

2270

How to assign a tablespace to a users in oracle?

991

how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?

5330

what is a Nested Loop join?

2039