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

Is there a combination of "like" and "in" in sql?

1070

I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.

2309

What are the different pseudo commands? Explain in general?

1081

How to get execution path reports on query statements?

990

How do I manually uninstall oracle client?

1095

How many categories of data types in oracle?

1032

What is the scope of a local variable?

1068

How to create tables for odbc connection testing?

1124

types of indexes and the rationale behind choosing a particular index for a situation.

2511

How to shutdown your 10g xe server from command line?

1092

Name the various constraints used in oracle?

1024

Differentiate between function and procedure in oracle.

1086

What is a system tablespace?

1086

Can we store images in oracle database?

1013

11. Display the client number and name and the client number and name of the person who referred that client.

2342