select * from emp e1 where (3=(select count(distinct (e2.sal))from emp e2

find out the second highest salary?

Question Posted / padiya hiten

Answer Posted / padiya hiten

select * from emp e1 where (3=(select count(distinct
(e2.sal))from emp e2 where e2.sal>=e1.sal));

Is This Answer Correct ?

4 Yes

6 No

Please Help Members By Posting Answers For Below Questions

How can windows applications connect to oracle servers?

1118

what is the use of system.effective.date variable in oracle?

1163

What is transaction control statement and how many types of transaction control statement in Oracle?

1236

WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?

2362

How to invoke the original export import utilities?

1135

what are archived logs?

2260

How to create a table in a specific tablespace?

1029

Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?

1070

What is a procedure in oracle?

1283

What does sharding mean?

1055

Explain oracle instance.

1234

How to write a query with an inner join in oracle?

1096

What are the differences between lov and list item?

1147

How to write text literals in oracle?

1119

Why should I use oracle database?

1049