SQL COUNT Explained: COUNT(*), COUNT(column), and COUNT(DISTINCT)
In this quick SQL tutorial, you’ll learn how to use the COUNT() function in different ways:
COUNT(*) – Count total rows in a table
COUNT(column) – Count non-null values in a specific column
COUNT(DISTINCT column) – Count unique, non-null values
This guide helps you understand how COUNT works in SQL.
Perfect for beginners learning SQL or preparing for data analyst interviews!
⏱️ Timestamps:
00:00 – Introduction
00:23 – How to count total rows using COUNT(*)
02:10 – How to count non-null values in a column with COUNT(column)
04:34 – How to count unique values using COUNT(DISTINCT column)
🔔 Don’t forget to like, subscribe, and drop your questions in the comments!
On this page of the site you can watch the video online SQL COUNT Explained: COUNT(*), COUNT(column), and COUNT(DISTINCT) with a duration of hours minute second in good quality, which was uploaded by the user Data Whisperer Academy 24 July 2025, share the link with friends and acquaintances, this video has already been watched 85 times on youtube and it was liked by 1 viewers. Enjoy your viewing!
