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
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
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
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
6:40
Excel COUNTIF & COUNTIFS Video Tutorial
402.2K viewsOct 29, 2010
YouTubeMyOnlineTrainingHub
2:11
How to use the COUNTIF function in Excel
1.5M viewsFeb 4, 2019
YouTubeTechOnTheNet
5:50
Writing CASE WHEN Statements in SQL (IF/THEN)
100.3K viewsJan 17, 2020
YouTubeBecoming a Data Scientist
14:36
How to use COUNTIF and COUNTIFS in Microsoft Excel
1M viewsJan 27, 2020
YouTubeKevin Stratvert
5:44
Basic Aggregate Functions in SQL (COUNT, SUM, AVG, MAX, and MIN)
131K viewsJan 7, 2020
YouTubeBecoming a Data Scientist
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
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
7:48
SQL Query | Compare with Previous Quarter's sales | Analytical Functions | Lead | Lag
40K viewsJun 10, 2020
YouTubeLearn at Knowstar
4:12
PL/SQL tutorial 9: IF THEN ELSE (IF-ELSE) Statement in PL/SQL by Manish Sharma
182.9K viewsSep 2, 2015
YouTubeManish Sharma
24:55
SQL Window Function | How to write SQL Query using RANK, DENSE RANK, LEAD/LAG | SQL Queries Tutorial
1.5M viewsMay 21, 2021
YouTubetechTFQ
See more