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 |
normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi
What is clustered table in Oracle?
How to load data from external tables to regular tables?
How to delete a column in an existing table?
The join defined by the default data link is an outer join yes or no ?
What is oracle update statement with inner join ?
How to define an anonymous procedure without variables?
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
What is partitioned table in Oracle?
How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?
Why do we need oracle client?
What are the different types of trigger and explain its various uses and functions?