Re: [SQL] Using count on a join, group by required?

If you showed your work, you might get decent hints if not solutions. On 12/14/2010 09:23 AM, Rob Sargent wrote: > Shouldn't you be doing your own homework? > > emaratiyya wrote: >> Hi,Please help me solving this problem. I appreciate..Thankyou. >> >> Create the following table and insert few arb

Re: [SQL] Aggregating by unique values

Perfect. Thanks, --Lee On 12/14/2010 03:23 AM, Filip Rembiałkowski wrote: try select zip, count(distinct id) from customer_service_date group by zip; 2010/12/14 Lee Hachadoorian Hello,

Re: [SQL] Using count on a join, group by required?

Shouldn't you be doing your own homework? emaratiyya wrote: Hi,Please help me solving this problem. I appreciate..Thankyou. Create the following table and insert few arbitrary records. Product (product_id, product_name, supplier_name, quantity, price_per_unit) You are required to create PL/SQ

Re: [SQL] Using count on a join, group by required?

what are the inputs to the PL-SQL procedure. On Tue, Dec 14, 2010 at 12:49 PM, emaratiyya wrote: > > Hi,Please help me solving this problem. I appreciate..Thankyou. > > Create the following table and insert few arbitrary records. > Product (product_id, product_name, supplier_name, quantity, pric

Re: [SQL] Aggregating by unique values

try select zip, count(distinct id) from customer_service_date group by zip; 2010/12/14 Lee Hachadoorian > Hello, > > I'm trying to count customers who have received services by ZIP code, > but I want to count each customer only once even though customers may > have received services on multiple

Re: [SQL] Using count on a join, group by required?

Hi,Please help me solving this problem. I appreciate..Thankyou. Create the following table and insert few arbitrary records. Product (product_id, product_name, supplier_name, quantity, price_per_unit) You are required to create PL/SQL package that achieves the following functionalities: •