The below code will retrieve distinct count from a table in SQL
select ename, count(ename) from emp
Group by ename having (count(ename)>1)
Distinct count in MS SQL
Published by
The below code will retrieve distinct count from a table in SQL
select ename, count(ename) from emp
Group by ename having (count(ename)>1)
