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

What is Segment Advisor in Oracle?

What is the difference between a hot backup and a cold backup in oracle?

What is raw datatype in oracle?

How do we get field details of a table?

What are the differences between a sys and system user and what are the extra privileges available to the sys user?

How to define a specific record type?

What are the factors that affect OPTIMIZER in choosing an Optimization approach ?

Hi Every One , What is the table Space in Oracle Database ? waiting for answere and thankyou

Hello All, Could any one provide me FAQs/interview questions on oracle PL/SQL

What is Parallel Server ?

What is the difference between SQL, DDL, and DML?

What are the system predefined user roles?

For more Oracle General Interview Questions Click Here