7. Repeat query (7) but also display all clients who have never ordered anythin

7. Repeat query (7) but also display all clients who have
never ordered anything.

Question Posted / deepakgunji

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

More Oracle General Interview Questions

What are main difference between Stored Procedure and Functions.

What is a proxy object?

What is oracle analytical function?

What is the difference between sharding and replication?

What is oracle in java?

What is an oracle recycle bin?

How to start an oracle instance?

When do I need to use a semicolon vs a slash in oracle sql?

can you call insert/update/delete in select statements. If yes how? If no what is the other way?

Describe varray?

How will you write a query to get a 5th rank student from a table student_report?

is there a tool to trace queries, like profiler for sql server?

For more Oracle General Interview Questions Click Here