SELECT ename, sal, COUNT() FROM employees GROUP BY ename, sal HAVING COUNT() > 1;
oracle 查询重复数据
最新推荐文章于 2024-10-12 08:22:34 发布
SELECT ename, sal, COUNT() FROM employees GROUP BY ename, sal HAVING COUNT() > 1;