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

What do you understand by database schema and what does it hold?

1179

How to find the duplicate rows count from employees table in oracle?

1041

Explain what are the uses of rollback segment?

960

what is the difference between functional dependecy and multilevel dependency?

2422

Difference between open_form and call_form in oracle.

1094

WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?

2153

what is the difference between data migration and production migration.

2276

What is redo log?

1006

What is hot backup and logical backup?

1002

What is a proxy class?

968

How to write a query with a left outer join in oracle?

1004

How many anonymous blocks can be defined?

1104

How to open and close an explicit cursor in oracle?

1001

Why do you use stored procedures and state some of its disadvantages?

970

Can we use oracle pl/sql block in core java? if so how? pls get back to me .....

2902