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
- 5410 Views
- Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / vijayaragavan
select clientnum, max(high_value_order) from ordertab group
by clientnum;
| Is This Answer Correct ? | 1 Yes | 0 No |
What are steps required to ENTER DATA INTO DWH?
What is a Private Synonyms ?
How to get last row id?
How many data types are supported?
Can an Integrity Constraint be enforced on a table if some existing table data does not satisfy the constraint ?
How to load excel data sheet to oracle database
what is the difference between primary key & foreign key?
57 Answers CTS, Infosys, La Multi, Sparsh, Wipro,
what is the difference between restoring and recovering?
What does sharding mean?
How to store pictures on to the database?
you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz
Explain drop constraint oracle?
Oracle General 
