Tutorial Gateway

Count Records in SQL Group

by

In this article we will show you, How to Count Records in SQL Group with example. For this, We are going to use the [MyEmployee table] table present in our [SQL Tutorial] Database. From the below figure you can observe that, [MyEmployee table] table have fourteen records

Count Records in SQL Group by 1

How to Count Records in SQL Group

Generally, we will write SQL queries to check for the total number of products belongs to particular category or color etc. In these situations we use GROUP BY clause to group the products by category, or color but, In order to count total number of records present in each group we have to use the COUNT Function. Let us see the Example

SQL CODE

-- How to Count Records in SQL Group
USE [SQL Tutorial]
GO
SELECT COUNT( [EmployeeID]) AS [Total Records]
      ,[Education]
      ,SUM([YearlyIncome]) AS Income
      ,SUM([Sales]) AS Sale
 FROM [MyEmployees Table]
 GROUP BY [Education]
 ORDER BY Income DESC

OUTPUT

Count Records in SQL Group by 2

TIP: The SQL Group By Clause will also group the NULL records, and count them as well. You can remove the NULL values by using the WHERE Clause with NOT NULL

Thank You for Visiting Our Blog