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
- 5524 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 |
Name the three major set of files on disk that compose a database in Oracle?
How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.
Can you assign multiple query result rows to a variable?
Explain drop constraint oracle?
What are the various constraints used in oracle?
difference between procedures and function?
Explain about achiever in sql?
What is the difference between SQL, DDL, and DML?
7 Answers BeBo Technologies, Wipro,
What is truncate oracle?
Assuming that you are an End User How to find that in the payment Batch some of the Invoice was Missing To pay How to find That??
What is redo log?
material view and view disadvantages?
Oracle General 
