查询指定店铺下tiltle名重复的sql语句
SELECT
*
FROM
tableName a
WHERE
( a.shop_id, a.`name` ) IN (
SELECT
shop_id,name
FROM
tableName
GROUP BY
shop_id,name
HAVING
count( * ) > 1
)
根据多个条件查询重复数据的可以依此类推
查询指定店铺下tiltle名重复的sql语句
SELECT
*
FROM
tableName a
WHERE
( a.shop_id, a.`name` ) IN (
SELECT
shop_id,name
FROM
tableName
GROUP BY
shop_id,name
HAVING
count( * ) > 1
)
根据多个条件查询重复数据的可以依此类推