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 to invoke the data pump import utility?

1143

What is rich query?

961

what is the difference between substr and instr function in oracle?

1067

Explain oracle’s server parameter file.

974

Describe varray?

1038

Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?

2336

What suggestions do you have to reduce the network traffic?

939

How is it different from a normal table?

1009

How do I spool to a csv formatted file using sqlplus?

1005

What is SQL access advisor in Oracle?

1178

What is flashback in Oracle?

1008

How to login to the server without an instance?

1145

How to do paging with oracle?

983

When system tablespace is created?

1017

What is oracle database 10g express edition?

1107