select max(sal) from emp where sal < (select max(sal) from emp)

Anybody can tell me, how do we find second largest emp
salary from emp table.. Thanks in advance ...

Question Posted / raj

Answer Posted / raj

select max(sal) from emp where sal < (select max(sal) from
emp)

Is This Answer Correct ?

31 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How to define a data source name (dsn) in odbc manager?

1028

what is the scripts in data base?

2153

How do I call oracle stored procedures that take no parameters?

1115

ABOUT IDENTITY?

2057

please explain.. DB architecture ...

2018

Explain the use of Merge statement in oracle 11g

1027

How different is ms access and oracle?

1036

How to define a procedure inside another procedure?

1022

How to view the tablespaces in the current database?

978

Can sub procedure/function be called recursively?

1001

How index is implemented in oracle database?

1006

What is snapshot is too old? Give and example for better understand.

1602

How to use "in out" parameter properly?

1046

Why do we need oracle client?

947

How to pass parameters to procedures in oracle?

1042