SELECT ID, 产品名称, 库存数量
FROM PRODUCT
WHERE 产品名称 IN (
SELECT 产品名称
FROM PRODUCT
GROUP BY 产品名称
HAVING COUNT(*) > 1
)SELECT R.ID, l.产品名称, R.库存数量
FROM PRODUCT L
JOIN PRODUCT R
ON L.产品名称 = R.产品名称
GROUP BY R.ID, l.产品名称, R.库存数量
HAVING COUNT(*) > 1
FROM PRODUCT
WHERE 产品名称 IN (
SELECT 产品名称
FROM PRODUCT
GROUP BY 产品名称
HAVING COUNT(*) > 1
)SELECT R.ID, l.产品名称, R.库存数量
FROM PRODUCT L
JOIN PRODUCT R
ON L.产品名称 = R.产品名称
GROUP BY R.ID, l.产品名称, R.库存数量
HAVING COUNT(*) > 1
where exists (
select * from product
where 产品名称=a.产品名称
and id<>a.id)
where b.产品名称=a.产品名称
and b.id<>a.id