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;
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;