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
- 5530 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 |
In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?
4. Display the order number and client number from the ORDER table. Output the result in the format. Client <clientno> ordered <orderno>
What is varray?
Can objects of the same schema reside in different tablespace?
What happens to the current transaction if a ddl statement is executed?
What is not equal to in oracle?
What is raw datatype in oracle?
what are the disadvantages of hierarchial database over RDBMS?
can anyone help me ? an index has been done on the primary key of a table. an update operation was performed on that table. now my question is 1> what abt the performance ? means faster or slower due to indexing ? 2> does the operation affect to the primary key constraint ?
How to define a data source name (dsn) in odbc manager?
what are actual and formal parameters?
What do database buffers contain?
Oracle General 
