Interested to Buy Any Domain ? << Click Here >> for more details...
7. Repeat query (7) but also display all clients who have
never ordered anything.
- 1 Answers
- 4102 Views
- Wipro, I also Faced
- E-Mail Answers
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 Data Segment ?
Can the query output be sorted by multiple columns in oracle?
How can you Enforce Referential Integrity in snapshots ?
How to assign query results to variables?
Which dictionary tables and/or views would you look at to diagnose a locking issue?
How many types of auditing in Oracle?
How to insert a record into a table?
How to resolve name conflicts between variables and columns?
Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?
How data locks are respected in oracle?
Explain the use of indexes option in exp command.
Which Department has MOST NUMBER of employees?
8 Answers IBM, LeadSquared, Mastek,
Oracle General 
