title: How to Use count and Group By with Self join in the same table in sql server 2008?
body: <p>I have a single table with columns of <code>st_name</code> and <code>id</code>. I need to get the count of <code>st_name</code> and Group by <code>st_name</code>. How do I do this?</p>