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
- 5325 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 |
How to use existing values in update statements using oracle?
Explain the use of control file?
What are the different types of failures that occur in Oracle database?
is database gud carrier option??
Explain the difference between replace() and translate() functions in oracle?
What is meant by raw datatype?
How can we manage the gap in a primary key column created by a sequence? Ex:a company has empno as primary key generated by a sequence and some employees leaves in between.What is the best way to manage this gap?
What is a nvl function? How can it be used?
How to assign data of the deleted row to variables?
What is Row Chaining ?
i can't insert column value greater than 4000 characters at one instance even i am using CLOB datatype . how to insert efficiently more than 4000 characters ? And please let me know how to impose inline and out-of line constraints on oracle column??? Thanks in Advance... Prakash
What is where clause in oracle?
Oracle General 
