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
- 4136 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Explain do view contain data?
How to write numeric literals in oracle?
How do you bind variables in oracle?
What are the advantages of oracle 12c?
Where do you use decode and case statements?
What is an oracle?
Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.
Explain the use of rows option in exp command.
How to get last row id?
How to work with data objects interactively?
How to list all tables in your schema?
What is snapshot is too old? Give and example for better understand.
How to export your own schema?
What is columnar storage what is the advantage?
What are the different types of synonyms?
