HomeProgramSQL Server

COUNT function in SQL Server

This article will show you in detail how to use functions that handle COUNT () numbers in SQL Server with specific syntax and examples to better visualize and capture functions.

Describe

The COUNT function in SQL Server is used to count the number of records (data, rows) contained in a data table. The values ​​NULL omitted do not count.

Syntax

To use the COUNT function in SQL Server, we use the following syntax:

 SELECT COUNT(cot) 
 FROM bang 
 [WHERE dieukien];

Parameters :

  1. cot: column or calculated value, the expression you want to count
  2. state: the table used to retrieve the record. Must have at least 1 table in the FROM clause.
  3. dieukien: optional. Conditions that the record must meet to be selected.

Note :

  1. The COUNT function can be used in later versions of SQL Server: SQL Server 2017, SQL Server 2016, SQL Server 2014, SQL Server 2012, SQL Server 2008 R2, SQL Server 2008, and SQL Server 2005.

For example

Take a look and explore some examples of COUNT functions in SQL Server.

Suppose, we have the following data table:

COUNT function in SQL Server Picture 1

Example 1: Count the number of categories in the table

 SELECT COUNT(*) 
 FROM Quantrimang 
 WHERE Sobai > 100; 
 
 Result: 5

In this example we count the number of categories in the Quantrimang table that are larger than 100.

Example 2: Use DISTINCT

The DISTINCT and COUNT commands can be used together to count the number of duplicate results.

 SELECT COUNT(DISTINCT Sobai) 
 FROM Quantrimang 
 WHERE Sobai > 100; 
 
 Result: 4

This example uses the keyword DISTINCT, so the repeated values ​​are counted only once. In the given data table, the value '101' appears twice, but only once, so the total number of calculated lines will be 4.

Example 3: Using GROUP BY

The following example counts all records related to a large section and you will do the following:

 SELECT Chuyenmuclon, COUNT(Chuyenmuccon) AS "So luong" 
 FROM Quantrimang 
 GROUP BY Chuyenmuclon; 
 
 Result: 
 Chuyenmuclon So luong 
 Laptrinh 3 
 Mang xa hoi 2 
 Trinh duyet web 1

Previous article: CEILING function in SQL Server

Next lesson: FLOOR function in SQL Server

5 ★ | 1 Vote
mssql functionsql server number handling functionsql server math function

You should read it

May be interested

  • DATEPART function in SQL ServerDATEPART function in SQL Server
    the datepart function in sql server returns a time value of the input argument, which can be day, month, year, quarter, hour, minute, second, millisecond ... the return value is an integer type (int)
  • DATENAME function in SQL ServerDATENAME function in SQL Server
    the datename function in sql server returns a time value of the input argument, which can be day, month, year, quarter, hour, minute, second, millisecond ... the return value is a string type (ascii)
  • How to use the COUNT function in ExcelHow to use the COUNT function in Excel
    the count function in excel is the basic counting function that is often used to count how many cells are in an area or in the entire spreadsheet.
  • The COUNTIFS function, how to use the cell count function according to multiple events in ExcelThe COUNTIFS function, how to use the cell count function according to multiple events in Excel
    the countifs function in excel to count cells satisfies many given conditions.
  • ROUND function in SQL ServerROUND function in SQL Server
    the article will give you detailed instructions on how to use the sql server round () function with the syntax and specific examples to make it easier to visualize and capture the function better.
  • CEILING function in SQL ServerCEILING function in SQL Server
    the ceiling function in sql server returns the smallest integer value greater than or equal to the transmitted numeric expression.
  • RIGHT function in SQL ServerRIGHT function in SQL Server
    the article will explore and guide you how to use the right function in sql server to extract some characters from the right side of a given string.
  • FLOOR function in SQL ServerFLOOR function in SQL Server
    the floor function in sql server returns the largest integer value but less than or equal to the transmitted numeric expression.
  • MONTH function in SQL ServerMONTH function in SQL Server
    this article will show you in detail how to use the datetime month () processing function in sql server with specific syntax and examples to better visualize and capture functions.
  • DATEDIFF function in SQL ServerDATEDIFF function in SQL Server
    this article will show you in detail how to use sql server's datetime datediff () function with syntax and specific examples to make it easier to visualize and capture functions.

SQL Server