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

how to get second highest sal of emp table

Question Posted / yadunandan

Answer Posted / yadunandan

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

Is This Answer Correct ?

5 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What are the tools for Oracle ?

1027

In oracle there is column command, how will you explain that?

993

What is the use of file param in imp command?

1136

What operating systems are supported by oracle database 10g xe?

1000

How to delete a user account in oracle?

928

11. Display the client number and name and the client number and name of the person who referred that client.

2295

How to revoke create session privilege from a user in oracle?

977

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

2090

Why do you use stored procedures and state some of its disadvantages?

986

6. Display the client name and order date for all orders using the traditional method.

2263

does the query needs a hint to access a materialized view?

1829

How to insert multiple rows with one insert statement in oracle?

1040

What is a read write transaction in oracle?

1053

What is the difference between a user and a schema in oracle?

1004

Explain oracle left join with an example?

964