select max(salary) from <TN> where salary not in(select max (salary)

5. Display full details for the creditor/s who has received
the single largest payment. Do not use a table join or set
operator anywhere in your query.

Question Posted / rajeev kumar

6 Answers
8122 Views
Wipro, I also Faced
E-Mail Answers

Answer Posted / rajeev kumar

select max(salary) from <TN> where salary not in(select max
(salary) from <TN>)

salary->field name

Is This Answer Correct ?

3 Yes

5 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is a proxy object?

1109

What is hash cluster in oracle?

1250

How to create a testing table in oracle?

1036

How many types of segments in Oracle?

1116

What is oracle rownum?

1018

How to use "out" parameter properly?

1125

What are the four Oracle system processes that must always be up and running for the database to be useable?

1054

How to load data from external tables to regular tables?

1106

How to return top 5 rows in oracle?

1115

What is oracle and what are its different editions?

1120

What is the relation of a user account and a schema in oracle?

1126

How to lock and unlock a user account in oracle?

1162

How to use like conditions in oracle?

1115

Does oracle partitioning improve performance?

1053

What happens to indexes if you drop a table?

1224