56,675
社区成员
发帖
与我相关
我的任务
分享
SELECT
*
FROM
article_product
WHERE
sort_num in (
SELECT
sort_num
FROM
article_product
GROUP BY
article_id
HAVING
sort_num = sort_num
)
AND article_id = 1
select * from table group by sort_num having count(1) >1