select *from <TN> where sal=(select max(sal) from <TN>);

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 / srikanth

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

Answer Posted / srikanth

select *from <TN>
where sal=(select max(sal) from <TN>);

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain the different normalization forms?

1156

How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?

1086

Explain the use of grant option in imp command.

1078

Explain enable novalidate constraint.

1131

What is a select query statement in oracle?

1026

What are privileges and grants?

1105

What happens if you lost a data file?

1080

How to use an explicit cursor without open statements?

1100

normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi

2262

How to insert a new row into a table in oracle?

1215

How to set up autotrace for a user account?

1111

How a database is related to tablespaces?

1081

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

1052

What is ADDM Advisor in Oracle?

1222

How to define a variable to match a table column data type?

1036