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 |
can u plz provide me oca sql dumps please i need them
How do I limit the number of rows returned by an oracle query after ordering?
What happens to indexes if you drop a table?
State any two functions of oracle?
Explain what does a control file contain?
What is a SNAPSHOT ?
How to calculate date and time differences in oracle?
Differentiate between TRUNCATE and DELETE?
How oracle handles dead locks?
how to join query for one source type is oracle another source type is sql server ?
What do you mean by a tablespace?
what is the use of triggers in Java program? I mean where do we use triggers in Java programming?