Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> Oracle >> Oracle General
  2. Suggest New Category

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

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

11. Display the client number and name and the client number and name of the person who referred that client.

2274

How would you best determine why your MVIEW couldnt FAST REFRESH?

1835

What is a user role in oracle?

1063

what is the use of triggers in Java program? I mean where do we use triggers in Java programming?

2127

What is concurrency in oracle?

946

Explain the use of show option in imp command.

1044

How to change user password in oracle?

973

What is set operator oracle?

920

What is the maximum number of triggers that can be applied to a single table?

953

How to export data to a csv file?

1200

What are the numeric comparison operations?

1050

What is SQL Tuning Advisor in Oracle?

1105

How to get last row id?

937

How can I get column names from a table in oracle?

982

What is meant by raw datatype?

1003