Distinct count in MS SQL Get link Facebook X Pinterest Email Other Apps June 14, 2017 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) Read more