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
5533 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 to view the tablespaces in the current database?

1027

What are group functions in oracle?

1096

Explain the dml?

1051

Can we insert data in view oracle?

1120

How to insert multiple rows with one insert statement in oracle?

1135

What is a private synonym?

1647

How can we find out the current date and time in oracle?

1132

What are the differences between number and binary_float in oracle?

1149

What is the relationship among database, tablespace and data file?

1039

What is ceil and floor in oracle?

1123

What are the attributes that are found in a cursor?

1122

How to declare a local variable?

1176

How to display employee records who gets more salary than the average salary in the department?

1126

How can I see all tables in oracle?

1061

What is an oracle data file?

1163