|
|
|
w*******y
发帖数: 60932 | 4 JOHNSONS HEAD TO TOE WASH 20 ounce 3 bottles $4.40
3 x baby johnsons head to toe wash 20 ounce botle (bonus size to a 15 ounce
bottle instore) = $3.79 each
Link:
http://www.toysrus.com/product/index.jsp?productId=2396448
sign up for $1.00 off Johnsons head to toe wash coupon and print 3 copies
for 3 bottles from johnsons website:
Link:
http://www.johnsonsbaby.com/offers
(other coupons available on the website)
use buy 2 get 1 free on any baby wash - babies r us coupon valid til 8/11/11
:
Link:
h... 阅读全帖 |
|
|
|
|
|
|
|
|
|
|
|
w*******y
发帖数: 60932 | 15 Today only you can purchase the 16 in. Cuddly Hearts Teddy (Pink and/or Blue
) for $16, BOGO promo code 97238
Add to that 15 in. Winter Wishes Teddy which is on sale for $5 with any
other bear purchase (I picked up 3, which qualified me for free shipping)
and don't forget, buy a $10 Gift Card for only $5 (search gift card to find
these)
all in all, 5 bears plus gift card (basically $5 free) totaled $41
Qualifies for free shipping with $40 purchase
Hope this helps someone. Please go easy on me, t... 阅读全帖 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
w*******y
发帖数: 60932 | 30 Cost Plus World Market has my favorite bed on sale for a super deal and
double discounted. Regular price is $400 - $450 (which is already a GREAT
price for the quality). Marked down to $319 - $359. Plus there is a 25%
off coupon bringing the price down to $239.
$0 Shipping if you pickup from the store!
Dove Grey Draper Upholstered Bed (Reg $400, Sale $319.99, FINAL PRICE $239.
99 w/coupon):
Link:
http://www.worldmarket.com/product/index.jsp?productId=11654362
Oatmeal Draper Upholstered Bed (... 阅读全帖 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
t*****e
发帖数: 1700 | 46 If the system doesn't support distinct count, do the following subquery
Select userid, count(productid) as ProdCount from
(select distinct userid, productid from Table)
group by userid
Q909) |
|
s**********v
发帖数: 1379 | 47 select userid, productid, count(*)
from (
select distinct * from table1
)
group by productid
好久不写sql了，就是先去除duplicate然后group by ?
Q909) |
|
d**e
发帖数: 6098 | 48 select number_of_type_product_purchased, count(*) number_of_customer
from
(select userid, productid, count(*) number_of_type_product_purchased
from table1
group by userid, productid)
group by number_of_type_product_purchased
order by number_of_type_product_purchased, number_of_customer;
Q909) |
|
i***e
发帖数: 3 | 49 select NoOfType as number_of_type_product_purchased, count(user) as number_
of_customer
from (
select userid, count(productid) as NoOfType
from (select distinct userid productid
from table1) a
group by userid) a1
group by NoOfType
order by number_of_type_product_purchased |
|
i******e
发帖数: 273 | 50 这个行吗？
select supplierID
from table
where productID in (
select distinct productID
from table
where supplierID = x) and
supplierID <> x; |
|
