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

why dont we assign not null constraint as table level constraint.

2796

Can a formula column be obtained through a select statement ?

2379

Explain oracle data types with examples?

1077

How to execute a stored procedure in oracle?

1144

Explain an exception and its types?

1134

From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.

1131

How to check the oracle tns settings?

1087

Why do we use bulk collect in oracle?

1104

State some uses of redo log files?

1064

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

1143

Is primary key indexed by default in oracle?

1046

Please explain oracle data types with examples?

1129

Can group functions be used in the order by clause in oracle?

1043

How to create tables for odbc connection testing?

1202

Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables

2115