select clientnum, max(high_value_order) from ordertab group by clientnum;

25. Display the client number and the value of the highest
value order placed by that client.

Question Posted / vijayaragavan

Answer Posted / vijayaragavan

select clientnum, max(high_value_order) from ordertab group
by clientnum;

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How many types of auditing in Oracle?

997

What is the difference between Delete, Truncate and Drop in Oracle?

1088

Is it possible to split the print reviewer into more than one region ?

2236

What is meant by raw datatype?

1021

Why we use bulk collect in oracle?

989

How to define a cusotmer as a supplier in ORACLE R12

2190

Explain implicit cursor.

971

Explain the use of analyse option in exp command.

1082

Why do we use coalesce function in oracle?

1072

Explain the use of online redo log files in oracle.

1005

How to write a left outer join with the where clause in oracle?

1042

Who developed oracle & when?

962

Explain do view contain data?

953

What are the advantages of oracle?

978

How are extents allocated to a segment?

1087