select client_name,count(item) from clients where item= (select Item from

23. Display the client name for all clients who have placed
an order where any order line has more than 3 items. Do not
use a table join anywhere in your query.

Question Posted / name

3 Answers
5420 Views
Wipro, I also Faced
E-Mail Answers

Answer Posted / name

select client_name,count(item) from clients where item=
(select Item from items )
having count(item)>3

Is This Answer Correct ?

3 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are privileges and grants?

1070

What is oracle sid?

957

What is difference between sid and service name in oracle?

966

What is Segment Advisor in Oracle?

1109

What is integrity and what is constraint??Explain with example

2290

How translate command is different from replace?

1096

What is the difference between pre-select and pre-query?

1226

What is bulk collect in oracle?

1004

Can you tell me how to add new column in existing views?how?How is possible?

1451

what are archived logs?

2205

How to synchronize 2 schema's objects?

2189

What is private procedure oracle?

1016

What is format trigger?

2077

Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun

2192

Hi Can any one tell me what are the API's used in requisition import.

1927