Retrieve the department number and salary ‘s duplicate records From emp-table ?

Retrieve data from emp table i.e How many duplicate records are present (department and salary wise) in emp-table

Select deptno,sal ,count(*) 
from emp 
group by deptno,sal Having  count(*)>1;
duplicate records From emp-table

Leave a Reply