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
- 5341 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 is the difference between authorization and authentication?
How do we know whether an index is created on a table ???
Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?
Explain constraining triggers.
what are the database links ?
What is the difference between RBBMS & DBMS?
What are various joins used while writing SUBQUERIES?
What is difference between UNIQUE constraint and PRIMARY KEY constraint ?
How to get maxsal , minsal, ename department wise in single query
What is oracle sid?
Is it possible to split the print reviewer into more than one region ?
21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.
Oracle General 
