25. Display the client number and the value of the highest
value order placed by that client.
- 2 Answers
- 5010 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 |
How to find no of saturdays in a month using single sql ?
How to pass a parameter to a cursor in oracle?
How to define a sub function?
Explain joins in oracle?
Which Department has MOST NUMBER of employees?
8 Answers IBM, LeadSquared, Mastek,
What is Library Cache in Oracle?
How to use subqueries with the exists operator in oracle?
How to rollback the current transaction in oracle?
What is a static data dictionary in oracle?
List the types of joins used in writing subqueries?
How to list all user accounts in oracle?
How much memory your 10g xe server is using?
Oracle General 
