SELECT
t1.id,
t1. NAME
FROM
teacher t1
WHERE
EXISTS (
SELECT
1
FROM
teacher t2
WHERE
t1. NAME = t2. NAME
AND t1.id != t2.id
)
筛选重复数据sql
最新推荐文章于 2023-07-22 17:50:26 发布