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

Explain a data segment?

1026

candidate key is subset of super key but not vice-verse explain

2028

What is logical backup in oracle?

978

What is a oracle database?

1007

How to create a table in a specific tablespace?

926

how the indexes are stored in the Oracle Database?

2227

Where do you use decode and case statements?

954

What are a collation and state the different types of collation sensitivity?

1115

What is oracle join syntax?

960

What is the difference between I and G in Oracle?

1037

In the oracle version 9.3.0.5.0, what does each number shows?

1243

Explain view?

990

Why we use bulk collect in oracle?

985

What do you mean by a deadlock?

1025

What is a tns service name?

958