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
7645 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

What is the maximum number of triggers that can be applied to a single table?

956

Explain the use of rows option in imp command.

1042

Explain a segment?

1020

What is the difference between I and G in Oracle?

1023

What is a proxy class?

969

What are the different oracle database objects?

1032

What happens if variable names collide with table/column names?

1105

What is primefaces used for?

1009

How many file formats are supported to export data?

1139

what are the default admin accounts in Oracle 10g ?

919

How do I limit the number of oracle database connections generated by weblogic server?

1007

What is the difference between count (*), count (expression), count (distinct expression)?

966

How to download oracle database 10g xe?

960

How to pass parameters to procedures?

975

What is the difference between substr and instr?

980