Interested to Buy Any Domain ? << Click Here >> for more details...
7. Repeat query (7) but also display all clients who have
never ordered anything.
- 1 Answers
- 4230 Views
- Wipro, I also Faced
- E-Mail Answers
Answer / anjum
select c.custid,c.name,count(o.ordid) from customer c left
join orders o on c.custid=o.custid group by c.custid;
| Is This Answer Correct ? | 1 Yes | 0 No |
What are the different types of failures that occur in Oracle database?
I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.
How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?
Is primary key indexed by default in oracle?
What are the Limitations of a CHECK Constraint ?
What is analyze command used for?
How to connect asp pages to oracle servers?
What is a partition in oracle?
Why do you use stored procedures and state some of its disadvantages?
What is cursor
What are operators in oracle?
what is the syntax of UPDATE command?
Oracle General 
