7. Repeat query (7) but also display all clients who have
never ordered anything.
- 1 Answers
- 3093 Views
- Wipro, I also Faced
- E-Mail Answers
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 Trigger in Oracle?
what is cartesian product?
What are the attributes that are found in a cursor?
How view is different from a table?
What are the differences between interval year to month and interval day to second?
How to install oracle odbc drivers?
What happens if the imported table already exists?
Explain database link?
Can we store images in oracle database?
What are the various types of snapshots ?
How to use windows user to connect to the server?
How do you store pictures in a database?
Oracle General 
