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
- 3979 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 varoius components of physical database structure of oracle database?
write sql query following source are EmpID, Salary 101 1000 102 2000 103 3000 I want the output format like following empid,sal,composite_sal 101 1000 1000 102 2000 3000 103 3000 6000
2. Display the item number and total cost for each order line (total cost = no of items X item cost). Name the calculated column TOTAL COST.
What is a data dictionary and how can it be created?
What is the difference between view and materialized view in Oracle?
After update how do u know how many records got updated
What is oracle open database communication (odbc)?
How to load a large xml file?
What are the restrictions on external table columns?
How to shutdown your 10g xe server?
How to write date and time interval literals in oracle?
Is it possible to enter only time value into a column of a table in sql?
Oracle General 
