18. Display the clientno and total value for all orders placed by that client.

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>

Question Posted / deepakgunji

2 Answers
5612 Views
Wipro, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

18. Display the clientno and total value for all orders placed by that client. Output the result in..

Answer / 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

18. Display the clientno and total value for all orders placed by that client. Output the result in..

Answer / guest

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 ?

0 Yes

1 No

Post New Answer