sql complex query

preetpalkpaoor · #1 (**permalink**) 02-04-12, 06:11

Hi All,

I have a question to be solved. Its a tricked one for me.

prod_id sale_date order_id quantity
p1 1/10/2012 1 2
p1 1/10/2012 2 5
p2 1/10/2012 1 3
p3 1/10/2012 2 6
p2 1/11/2012 6 2
p3 1/11/2012 6 3
p1 1/12/2012 9 3
p2 1/12/2012 9 6
p3 1/12/2012 9 7

Above shown is a table (name-sales_rec)

Now if i want to fetch the PROD_ID WHICH IS SOLD IN ALL THE THREE DAYS i.e. 10th ,11th,12th jan. and also the quantity also.

How can we find this?

Could some one please help me.

Thanks in advance.

Preetpal kapoor

r937 · #2 (**permalink**) 02-04-12, 06:23

Code:

SELECT prod_id
     , SUM(quantity)
  FROM sales_rec
 WHERE sale_date IN ( '2012-01-10'
                    , '2012-01-11'
                    , '2012-01-12' )
GROUP
    BY prod_id  
HAVING COUNT(DISTINCT sale_date) = 3

preetpalkpaoor · #3 (**permalink**) 02-05-12, 12:14

Thank you buddy.

Internet Services

Web Development

Digital Marketing

Consumer Tech