7. Repeat query (7) but also display all clients who have never ordered anythin

7. Repeat query (7) but also display all clients who have
never ordered anything.

Question Posted / deepakgunji

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

More Oracle General Interview Questions

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?

For more Oracle General Interview Questions Click Here