Select sal from emp a where 2=(select count(distinct sal) from emp b wher

1.how to extract the second highest salary from emp table
having sal as a column which contains the salary of all
employee of an organisation.

Question Posted / hema

Answer Posted / hema

Select sal from emp a where 2=(select count(distinct sal)
from emp b where a.sal <= b.sal)

Is This Answer Correct ?

2 Yes

2 No

Please Help Members By Posting Answers For Below Questions

how to make an oracle object

2338

query optmization techniques and quwry analyser+projects+ppts

2402

How to drop a stored function?

1124

How to create a table interactively?

1062

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

1017

How to create a table in a specific tablespace?

948

what is insert all statement in sql

6481

How to export data to a csv file?

1271

How to insert a new row into a table in oracle?

1137

How to use like conditions in oracle?

1023

What is clustered table in Oracle?

1169

Explain the use of file option in exp command.

1115

How to check the oracle tns settings?

1030

How to pass a cursor variable to a procedure?

1091

What is rowid and rownum in oracle?

992