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
- 4227 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 is a Nested Loop join?
Can an Integrity Constraint be enforced on a table if some existing table data does not satisfy the constraint ?
What are the sql clauses supported in the link property sheet ?
how to store only time in a data base table
select trunc(round(156.00,-1),-1) from dual;
What is object data modeling?
What is the minimum client footprint required to connect c# to an oracle database?
How to drop a stored procedure in oracle?
What to do if the startbd.bat failed to start the xe instance?
How to increment dates by 1 in oracle?
22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100
What is using clause and give example?
Oracle General 
