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 is concurrency in oracle?

1008

Give the various exception types.

993

How to run create database statement?

1034

Explain the use of record option in exp command.

1006

How to view existing locks on the database?

1053

What is dynamic proxy?

1008

what are the advantages of running a database in archive log mode?

2203

What is catalog in Oracle?

1367

How to create a table index in oracle?

1134

What are the different pseudo commands? Explain in general?

1080

How to bring a tablespace online?

1079

Explain oracle data types with examples?

1030

What is the data type of dual table?

995

What is integrity and what is constraint??Explain with example

2284

How to rename an existing table?

1129