Interested to Buy Any Domain ? << Click Here >> for more details...
4. Display the order number and client number from the ORDER
table. Output the result in the format. Client <clientno>
ordered <orderno>
- 1 Answers
- 4712 Views
- Wipro, I also Faced
- E-Mail Answers
select 'Client '|| nvl (to_char(client_no),'unknown') ||'
has placed order to the value of '|| nvl(sum(order_no),0)
order_summary
from order
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 | 1 No |
What is the difference between Outer join and Full outer join?
I need to get the values of the previous quarter.how to do this?eg: if my cuurent month is may i need to get the datas of the month jan,feb,march.Can it be done in oracle.I tried with date function q but for the month jan its not retriving the previous quarter(oct-dec).how to solve this.plpz anyone help me?
How to store pictures on to the database?
Can we write dml statement in function in oracle?
Is it possible to insert comments into sql statements return in the data model editor ?
Which Department has MOST NUMBER of employees?
8 Answers IBM, LeadSquared, Mastek,
What to do if the startbd.bat failed to start the xe instance?
How to invoke the data pump export utility?
what is meant by magic query
Difference between open_form and call_form in oracle.
how to find the second highest salary in a given table????
State and explain about oracle instance?
Oracle General 
