SQL Tips | Difference between Count(*) and Count(col) | Avoid this mistake

In this video, we understand the use of Count function in SQL Server and how to avoid making mistakes with the Count function.

Book a private One-on-One 1 hour training session - SQL for Beginners

Video with detailed explanation on difference between Count(*), Count(1) and Count(colname) -

How to install SQL Server for practice?

Check out the complete list of SQL Query Interview Questions -

Must Do Data Analytics Certifications -

Google Data Analytics Professional Certificate

Google Advanced Data Analytics Professional Certificate

Best Data Science / Analytics / SQL courses
Learn SQL Basics for Data Science Specialization

Beginners to Python Programming

Data Science and Business Analytics with Python

IBM Data Science Professional Certificate

Data Science Fundamentals with Python and SQL Specialization

Python for Everybody Specialization

Google Data Analytics Professional Certificate

Coursera Plus - Data Science Career Skills

Please do not forget to like, subscribe and share.

For enrolling and enquiries, please contact us at