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 relational database management system?

1120

How to run create database statement again?

1158

Explain the use of full option in exp command.

1116

How to define a record variable to store a table row?

1058

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

1116

What are the ways tablespaces can be managed and how do they differ?

2368

How to run create database statement?

1034

Whats the benefit of dbms_stats over analyze?

2003

what's query optimization and without use of IN AND Exist can we get another way data from query

2141

How to create an initialization parameter file?

1055

How to create a stored program unit?

1229

Is there a function to split a string in plsql?

1062

What is data type in oracle?

1125

What is oracle used for?

1026

Describe varray?

1059