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.

SQL Bootcamp: Live & Hands-on, In NYC or Online, Learn From Experts, Free Retake, Small Class Sizes,  1-on-1 Bonus Training. Named a Top Bootcamp by Forbes, Fortune, & Time Out. Noble Desktop. Learn More.

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.

How to Learn SQL

Master SQL with hands-on training. SQL is one of the most in-demand programming languages and is used across a variety of professions.

Yelp Facebook LinkedIn YouTube Twitter Instagram