asterisk-solid All courses are temporarily held live online with an extended free retake period. Learn More.

window-close-line
Hero image for SQL COUNT Tutorial

SQL COUNT Tutorial

SQL Tutorial: COUNT Function with Pictures

In this tutorial, we'll go through the basics of the COUNT function in SQL, the syntax of it, and walk through an example of the COUNT function.

COUNT Function

  • The COUNT function returns the number of rows in the data based on the given criteria.

  • It returns the count of entries or rows that meet the condition.

  • Syntax: SELECT COUNT(column_1) FROM table WHERE condition ;

Example

Let’s say we have a basketball league and we keep records of each player, which team they are on, and their basic statistics. 

Stats Table

If we wanted to use a SQL query to find the number of players on team C, we would write the following:

SQL COUNT Function

Once we hit enter and run, our result should be 4 because there are 4 players on team C.

Master SQL in hands-on training