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
7641 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 do you understand by a database object? Can you list a few of them?

969

What is MTTR advisor in Oracle?

1033

How to add another datafile to a tablespace?

989

How do you bind variables in oracle?

927

How to define default values for formal parameters?

980

How to use null as conditions in oracle?

1000

What is the database name in oracle?

967

What is a system tablespace?

1001

What to do if the binary spfile is wrong for the default instance?

997

How to Truncate Table in Oracle

1089

Explain the use of control file?

1060

what is the scripts in data base?

2075

What happens if the imported table already exists?

970

How to delete multiple rows from a table in oracle?

1002

What is set verify off in oracle?

1029