03 2012 档案
摘要:表结构:用户购买过的商品记录表product_buy主要列:user_name product_idA 1B 1C 2A 3A 2查询同时购买了product_id为 1,2,3的SQL语句:SELECT user_name FROM product_buy WHERE product_id in(1,2,3) GROUP BY user_name HAVING COUNT(DISTINCT product_id) = 3;要点:COUNT(DISTINCT ...)
阅读全文