select clientnum,high_value_order from ordertab where high_value

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

Question Posted / uday shankar chejerla

Answer Posted / uday shankar chejerla

select clientnum,high_value_order from ordertab where
high_value_order=(select max(high_value_order) from
ordertab);

Is This Answer Correct ?

5 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How can I see all tables in oracle?

1009

How to do clean up if create database failed?

1026

Explain what are synonyms used for?

1034

How can I introduce multiple conditions in like operator?

984

Can we save images in a database and if yes, how?

1063

Why do we use bulk collect in oracle?

1058

Please explain oracle data types with examples?

1068

How can you use check constraints for self referential integrity?

969

Why does for update in oracle 8 cause an ora-01002 error?

1003

Difference between open_form and call_form in oracle.

1158

How to join two tables in a single query using oracle?

995

What is oracle sid?

950

What is rowid and rownum in oracle?

1011

How to run create database statement?

1032

What is the difference between postgresql and oracle?

1048