Introduction to SQL Group By with Count
In this step by step SQL tutorial I will show you how to use Group by clause witch count aggregate function. For the purpose of this tutorial I will use SQL Server 2008 R2.
Prior knowledge: It might be easier for you to follow this tutorial if you have knowledge of Group By clause
for more information visit SQL Group By tutorial
To get full access to this page
SQL Group By Count Rows
In our example we will use DimCustomer table which contains 18494 rows.
Let's check what we have in our table that we can Group and count. Gender seems to be a good choice.
Become a member or Sign in
Membership is just $3.99/month