Interested to Buy Any Domain ? << Click Here >> for more details...
25. Display the client number and the value of the highest
value order placed by that client.
- 2 Answers
- 5329 Views
- Wipro, I also Faced
- E-Mail Answers
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 |
Post New Answer View All Answers
How to set a transaction to be read only in oracle?
What is oracle thin client?
What is object data modeling?
How to add another datafile to a tablespace?
What is index in Oracle?
How to start your 10g xe server?
What are temporal data types in oracle?
What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?
What to do if the binary spfile is wrong for the default instance?
Differentiate between post-database commit and post-form commit?
how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?
What is the usage of analyze command in oracle?
what is the difference between restoring and recovering?
How to add a new column to an existing table in oracle?
What is tns service name?
