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
- 5433 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 |
Difference between cartesian join and cross join?
What is tablespace in oracle? how can we create? how is it manage? . . . Thnx 2 All in Advnc....:)
How to grant create session privilege to a user in oracle?
From the database level, how can you tell under which time zone a database is operating?
How do we display rows from the table without duplicates?
How to define default values for formal parameters?
18. Display the clientno and total value for all orders placed by that client. Output the result in the following format: Client <clientno> has placed orders to the value of <total value>
Define oracle database
How to generate query output in html format?
Can objects of the same schema reside in different tablespace?
How to declare a local variable?
select trunc(round(156.00,-1),-1) from dual;
Oracle General 
