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 |
How many types of synonyms in Oracle?
How to export data to a csv file?
Explain a private synonyms?
How to display row numbers with the records?
How to find no of saturdays in a month using single sql ?
Query to retrieve record for a many to many relationship ?
Explain an exception and its types?
Can Multiple instances be run on Single Machine???
What is program global area (pga) in oracle?
How can Oracle users be audited?
How to insert multiple rows with one insert statement in oracle?
What is save point in oracle database?