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
- 5411 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / vijayaragavan
select clientnum, max(high_value_order) from ordertab group
by clientnum;
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to define an external table with a text file?
What is index in Oracle?
What is oracle latest version?
Explain self joins in oracle?
how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....
How would you begin to troubleshoot an ORA-3113 error?
Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?
How to define a procedure inside another procedure?
What is the difference between post-database commit and post-form commit?
What do you understand by a database object? Can you list a few of them?
Can we save images in a database and if yes, how?
What are the uses of Database Trigger ?
Can group functions be used in the order by clause in oracle?
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?
How to start a new transaction in oracle?
