Re: sql query help

DA Morgan wrote...
> steve wrote:
>
>> hi peeps
>>
>> i have a table set up
>>
>> table: orderitems
>> orderid
>> productid
>> qty
>>
>> is there anyway of listing productid of items ordered x times?
>>
>> i have managed to get basic things working but found no reference to this
>> and not sure if the set up of my database would allow such a query
>>
>> cheers :)
>>
>> --
>> get me tools and beer
>
> There is indeed.
>
> SELECT productid, COUNT(*)
> FROM orderitems
> GROUP BY productid
> HAVING COUNT(*) = x;
>
> Go to http://tahiti.oracle.com and search on GROUP BY.
>
> Daniel Morgan

Thanks very much.

I didnt know it was possible, done a search on google gave me loads of other stuff and I didnt have any idea how to word the search. Never occured to me to check the oracle site!

Thanks again :)

--
get me tools and beer