Guys See the correct answer. select distinct sal from emp a where 4 =

find out the third highest salary?

Question Posted / sam

Answer Posted / sam

Guys
See the correct answer.

select distinct sal from emp a where 4 =(select
count(distinct(sal)) from emp where a.sal <= sal)

Is This Answer Correct ?

2 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is a proxy class?

557

How to retrieve data from an explicit cursor?

559

What are a cluster and non-cluster index?

576

what is the difference between restoring and recovering?

557

How to get the Installed Oracle Version Information ?

624

How to connect to the server with user account: sys?

564

Explain alias?

711

what are actual and formal parameters?

596

What is a nvl function? How can it be used?

561

How can windows applications connect to oracle servers?

522

Explain the use of parfile option in exp command.

526

How to export your own schema?

572

How to retrieve data from an cursor to a record?

563

Explain the difference between sap and oracle?

575

What are the uses of a database trigger?

516