Interested to Buy Any Domain ? << Click Here >> for more details...
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>
- 2 Answers
- 5448 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / girija.112
i forgot to login thats why i have posted it once again
ANS:
select 'Client '||nvl(tochar(client_no,'unknown') ||' has
placed orders to the value of '|| nvl(sum(orders),0) as
order_summary
from order_table
group by client_no;
OUTPUT.....
ORDER_SUMMARY
-----------------------------------------------------
Client unknown has placed order to the value of 200
Client 1006 has placed order to the value of 4
Client 1008 has placed order to the value of 0
Client 1004 has placed order to the value of 54
Client 1005 has placed order to the value of 450
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain the use of indexes option in exp command.
please explain.. DB architecture ...
Assuming that you are an End User How to find that in the payment Batch some of the Invoice was Missing To pay How to find That??
How to call a sub procedure?
Query to retrieve record for a many to many relationship ?
What is raw datatype?
What are the attributes of cursor?
What is the difference between $oracle_base and $oracle_home?
What are the advantages of oracle?
Explain what are the advantages of views?
How to define an anonymous block?
What is oracle and what are its different editions?
WHAT IS ecc 6.0
what is dynamic SGA and static SGA
How to assign a tablespace to a users in oracle?
