SELECT
COUNT(`id`) AS total,
id,
member_id,
shop_id
FROM
counsellor
WHERE expect_counseling_fee > 0
GROUP BY member_id,
shop_id
HAVING total > 1
SELECT
COUNT(`id`) AS total,
id,
member_id,
shop_id
FROM
counsellor
WHERE expect_counseling_fee > 0
GROUP BY member_id,
shop_id
HAVING total > 1
本文标题:查重SQL
本文链接:https://www.haomeiwen.com/subject/helszhtx.html
网友评论