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

find out the third highest salary?

Question Posted / neha

Answer Posted / neha

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

Is This Answer Correct ?

103 Yes

31 No

Please Help Members By Posting Answers For Below Questions

What is object data modeling?

971

How to fetch the row which has the max value for a column?

1004

What is open database communication (odbc) in oracle?

1007

How to retrieve data from an cursor to a record?

1111

how to handle exceptions in post production

1436

Explain index?

1267

What are joins, explain all types of joins?

2300

How to manage transaction isolation level?

1012

How to write numeric literals in oracle?

1191

Briefly explain what is literal? Give an example where it can be used?

1049

How to test null values?

1114

What is a package in oracle?

1111

What is a synonym? What are its various types?

1116

What are advantages of dateset in datastage?

2268

How to define an anonymous block?

1166