Run the below SQL Statement to find the number of duplicate rows:
1 2 |
Select DEPTNO,count(*) from EMP group by DEPTNO having count(*) > 1 |
Thank You
Run the below SQL Statement to find the number of duplicate rows:
1 2 |
Select DEPTNO,count(*) from EMP group by DEPTNO having count(*) > 1 |
Thank You