25. Display the client number and the value of the highest
value order placed by that client.
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 an oracle table?
How to set up autotrace for a user account?
what are different types of deletes?
What is the difference between count (*), count (expression), count (distinct expression)?
How to check database size in Oracle?
5. Display full details from the ORDER_LINE table where the item number is (first condition) between 1 and 200 (no > or < operators) OR the item number is greater than 1000 AND (second condition) the item cost is not in the list 1000, 2000, 3000 OR the order number is not equal to 1000.
How to calculate date and time differences in oracle?
Is oracle an open source?
defination of bitmap index
State and explain the different types of data models?
What is meant by recursive hints in oracle?
What is an UTL_FILE.What are different procedures and functions associated with it?