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
7830 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 a initialization parameter file in oracle?

1018

What is an oracle?

994

What are the differences between char and varchar2 in oracle?

1140

What is an oracle function?

1128

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

1152

What are the general rules on data consistency?

988

what's query optimization and without use of IN AND Exist can we get another way data from query

2116

What is a sub query? Describe its types?

996

What is an Oracle Instance?

1104

How to drop a stored function?

1124

Explain the use of constraints option in exp command.

1026

How to count duplicated values in a column in oracle?

1022

What is system global area (sga) in oracle?

966

How to delete multiple rows from a table in oracle?

1050

What is recovery manager in Oracle?

1035