Number of records in a table with different conditions by using SQL count() in less than 2 minutes
Number of records in a table with different conditions by using SQL count() in less than 2 minutes
May 17, 2020
plus2net.com
COUNT(*) ≠ COUNT(column) 🧮 Many SQL users assume both do the same — but they don’t. --- 🔹 What’s the difference? COUNT(*) Counts all rows in the table Includes rows with NULL values COUNT(column) Counts only non-NULL values in that column Rows with NULL in the column are ignored --- 📌 Example insight If a table has 5 rows but only 3 rows contain a value in a column, then: COUNT(*) → 5 COUNT(column) → 3 --- 💡 Key takeaway: Use COUNT(*) when you want total rows. Use COUNT(column) when you care
0:23
COUNT(*) ≠ COUNT(column) 🧮 Many SQL users assume both do the same — but they don’t. --- 🔹 What’s the difference? COUNT(*) Counts all rows in the table Includes rows with NULL values COUNT(column) Counts only non-NULL values in that column Rows with NULL in the column are ignored --- 📌 Example insight If a table has 5 rows but only 3 rows contain a value in a column, then: COUNT(*) → 5 COUNT(column) → 3 --- 💡 Key takeaway: Use COUNT(*) when you want total rows. Use COUNT(column) when you care
861 views4 months ago
FacebookData Driven Insights
SQL Server Transaction Count with Mismatching Number BEGIN and COMMIT
SQL Server Transaction Count with Mismatching Number BEGIN and COMMIT
Sep 14, 2015
mssqltips.com
How to count the number of rows in a table in SQL Server - Brent Ozar Unlimited®
How to count the number of rows in a table in SQL Server - Brent Ozar Unlimited®
Feb 18, 2014
brentozar.com
SQL percentage calculation examples in SQL Server
SQL percentage calculation examples in SQL Server
168 viewsJan 19, 2022
sqlshack.com
Understanding the SQL Server CASE statement
Understanding the SQL Server CASE statement
168 viewsJun 28, 2019
sqlshack.com
SQL While loop: Understanding While loops in SQL Server
SQL While loop: Understanding While loops in SQL Server
168 viewsNov 6, 2019
sqlshack.com
SQL IF Statement introduction and overview
168 viewsMay 20, 2019
sqlshack.com
IF-THEN logic in SELECT and WHERE with CASE expressions in Oracle SQL
Dec 7, 2023
oracle.com
Overview of the T-SQL If Exists statement in a SQL Server database
168 viewsMar 3, 2020
sqlshack.com
SQL Average Function to Calculate Average of a set of SQL Server Rows
Jun 22, 2022
mssqltips.com
SQL IF Statement for Conditional Logic
Sep 12, 2022
mssqltips.com
Row Count Transformation in SSIS
May 12, 2015
tutorialgateway.org
SQL Loop through Table Rows without Cursor
Sep 11, 2019
mssqltips.com
2:04
SQL Count condition in main Query
3 views1 month ago
YouTubeRoel Van de Paar
1:15
How to use COUNT function in Microsoft SQL Server | COUNT() function #shorts #sqlserver #sqlcommands
97 views1 month ago
YouTubeWideLearning
3:59
SQL CASE WHEN with SUM Function in SQLite | Count Multiple Conditions in One Query
4 views2 months ago
YouTubeShivam Sharma Analytics
8:52
The SQL EXISTS clause
68.5K viewsOct 27, 2015
YouTubeDatabase by Doug
7:26
Intermediate SQL Tutorial | Case Statement | Use Cases
332.4K viewsApr 2, 2020
YouTubeAlex The Analyst
4:46
SQL Aggregates: COUNT(*) aggregate function
120.1K viewsFeb 1, 2017
YouTubeJames Marks
5:50
Writing CASE WHEN Statements in SQL (IF/THEN)
100.3K viewsJan 17, 2020
YouTubeBecoming a Data Scientist
15:05
How to Create a Database, Add Tables and Import Data in MySQL Workbench
735.5K viewsAug 31, 2020
YouTubeMatt Macarty
5:44
Basic Aggregate Functions in SQL (COUNT, SUM, AVG, MAX, and MIN)
131K viewsJan 7, 2020
YouTubeBecoming a Data Scientist
5:22
CASE STATEMENT IN SQL WITH 3 EXAMPLES | SQL TUTORIAL FOR BEGINNERS
69.5K viewsAug 18, 2020
YouTubeCrack Concepts
10:52
Conditional Statements (If, else) & Loops in SQL Server | English
24.6K viewsJul 12, 2021
YouTubeThe Amazing Codeverse
10:09
Introduction to Queries with MySQL Workbench & Sakila Sample Database
124.5K viewsDec 7, 2020
YouTubeMatt Macarty
6:47
How to count colored cells in Excel
278.2K viewsApr 19, 2020
YouTubeBarb Henderson
6:14
SQL Basics Tutorial For Beginners | Select + From Statements | 2/4
533.8K viewsMar 1, 2020
YouTubeAlex The Analyst
4:55
PL/SQL tutorial 10: PL/SQL IF THEN ELSIF Statement in Oracle Database by Manish Sharma
150.3K viewsSep 9, 2015
YouTubeManish Sharma
16:01
SQL Query | How to calculate YTD and MTD totals | Window Functions
47.6K viewsNov 10, 2020
YouTubeLearn at Knowstar
See more