-
How to display duplicate rows in a table?
select * from emp where deptno=any(select deptno from emp having count(deptno)>1 group by deptno);
select * from emp where deptno=any(select deptno from emp having count(deptno)>1 group by deptno);
Please Turn OFF your ad blocker
- OR -
LOGIN to continue using GeekInterview website.