7. Repeat query (7) but also display all clients who have
never ordered anything.
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 OUTER JOIN?
What are the factors causing the reparsing of SQL statements in SGA?
Is it possible to insert comments into sql statements return in the data model editor ?
What are the original export and import utilities?
How to find the date and time of last updated table?
What are the advantages of Views ?
How to create an oracle database?
List the parts of a database trigger.
Which environment variables are absolutely critical in order to run the OUI?
In Oracle 10g, "g" Stands for what?
How do I call oracle stored procedures that take no parameters?
what is difference between table and view? where to use views? thanks in advance!