[Rahulbatra]

Suppose you have a emp table with empname column you can associate columns having same empname as below:
SELECT empname, COUNT(*) from emp GROUP BY empname

Let me know if you have any doubts.