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
- 5456 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 |
where do i find oracle interview questions.
How to build data dictionary view an new database?
which language is used to develop the oracle........?
How to display First 4 rows From Database Table?
How to delete a user account in oracle?
What is bulk collect in oracle?
How to use "while" statements in oracle?
How to connect asp pages to oracle servers?
Is insert autocommit in oracle?
What is the effect of setting the value "CHOOSE" for OPTIMIZER_GOAL, parameter of the ALTER SESSION Command ?
defination of bitmap index
what is primary key?
Oracle General 
