select client_name,count(item) from clients where item in (select Item fr

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 / rharshad

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

Answer Posted / rharshad

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

Is This Answer Correct ?

1 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?

2344

What is MTTR advisor in Oracle?

1090

What are the oracle differences between nvl and coalesce

1149

What privilege is needed for a user to create views in oracle?

1050

What is a named program unit?

1086

What are the differences between char and nchar in oracle?

1096

How do I reset a sequence in oracle?

1098

Who developed oracle & when?

1003

How do I use os authentication with weblogic jdriver for oracle and connection pools?

1051

WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?

2314

Explain view?

1037

What is oracle latest version?

1096

Is it possible to insert comments into sql statements return in the data model editor ?

2560

How do we represent comments in oracle?

1048

How do we create privileges in oracle?

1047