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 |
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,