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 ...) 阅读全文
posted @ 2012-03-05 23:42 Amwpfiqvy 阅读(1599) 评论(0) 推荐(1) 编辑

点击右上角即可分享
微信分享提示