7. Repeat query (7) but also display all clients who have
never ordered anything.
- 1 Answers
- 3544 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 are the components of Logical database structure of ORACLE database?
Calculate difference between 2 date / times in oracle sql?
How many different types of indexes we have in oracle?
24 Answers IBM, TCS,
What is control file used for?
How do we get field detail of a table?
i deleted 4 records form the table.after i have applied commit .now i want to get back those records.how?
What is a Tablespace?
Explain about achiever in sql?
Assuming that you are an End User How to find that in the payment Batch some of the Invoice was Missing To pay How to find That??
Difference between join and a subquery?
8 Answers Base Automation, NMDC,
HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.
What is a cluster Key ?
Oracle General 
