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

find out the second highest salary?

Question Posted / karthikeyan

Answer Posted / karthikeyan

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

Is This Answer Correct ?

7 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is the use of file param in imp command?

860

How to use "in out" parameter properly?

778

What is index in Oracle?

779

how to make an oracle object

2068

Which is better Oracle or MS SQL? Why?

5819

How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?

2937

Where is the export dump file located?

764

What is blob datatype?

748

How to rename a column in an existing table?

779

How to add another datafile to a tablespace?

791

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

779

How to check the server version in oracle?

805

Why do we use bulk collect in oracle?

777

ABOUT IDENTITY?

1741

What is the relation of a user account and a schema in oracle?

823