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

find out the third highest salary?

Question Posted / ram pravesh

Answer Posted / ram pravesh

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

Is This Answer Correct ?

2 Yes

2 No

Please Help Members By Posting Answers For Below Questions

How to run create database statement?

1032

Can we protect our pl/sql source code?

1042

How to retrieve data from an cursor to a record?

1102

How to define a variable of a specific record type?

1077

What is hot backup and logical backup?

1051

In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?

2341

What are privileges and grants?

1066

What is the difference between online and offline backups?

1058

How to save query output to a local file?

1026

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

2141

various types of hints and their usage

2697

How to define default values for formal parameters?

1044

What is analyze command used for?

1071

What is the simplest tool to run commands on oracle servers?

1009

What is primefaces used for?

1049