SQL FULL JOIN tutorial: return all rows from both tables, NULL where no match, find mismatches on either side, and emulate FULL JOIN in MySQL and SQLite.
Author: PK
Meet PK, the founder of NeotechNavigators.com! With over 15 years of experience in Data Visualization, Excel Automation, and dashboard creation. PK is a Microsoft Certified Professional who has a passion for all things in Excel. PK loves to explore new and innovative ways to use Excel and is always eager to share his knowledge with others. With an eye for detail and a commitment to excellence, PK has become a go-to expert in the world of Excel. Whether you're looking to create stunning visualizations or streamline your workflow with automation, PK has the skills and expertise to help you succeed. Join the many satisfied clients who have benefited from PK's services and see how he can take your data analysis skills to the next level!
SQL RIGHT JOIN: Keep All Rows from the Right Table (Examples)
SQL RIGHT JOIN tutorial: return every row from the right table with matching left rows or NULL, RIGHT JOIN vs LEFT JOIN, find orphan records, and examples.
SQL Joins Explained: INNER, LEFT, RIGHT and FULL JOIN Basics
SQL joins explained: how JOIN combines rows from two tables on a key, the four join types compared on one sample dataset, ON vs WHERE, and which join to use.
SQL Aliases: Rename Columns and Tables with AS (Examples)
SQL aliases tutorial: rename columns and tables with AS, name calculated columns, shorten join queries with table aliases, and where aliases can be used.
SQL BETWEEN Operator: Filter Values in a Range (Examples)
SQL BETWEEN operator tutorial: filter numbers, dates and text within an inclusive range, NOT BETWEEN, the end-of-day date trap, and examples with output.
SQL IN Operator: Filter by a List of Values (Examples)
SQL IN operator tutorial: match a column against a list of values, NOT IN, IN with a subquery, IN vs OR, the NULL trap with NOT IN, and examples with output.
SQL Wildcards: %, _, [ ] and Escape Characters Explained
SQL wildcards explained: the % and _ characters, SQL Server [ ] ranges, escaping literal % or _, worked examples with results and common mistakes.
SQL LIKE Operator: Pattern Matching with % and _ (Examples)
SQL LIKE operator tutorial: match text patterns with % and _ wildcards, NOT LIKE, case sensitivity by database, and worked examples with output.
SQL COUNT, AVG and SUM Functions: Aggregate Data (Examples)
SQL COUNT, AVG and SUM tutorial: count rows, total and average a column, COUNT(*) vs COUNT(column), how NULLs are ignored, and examples with output.
SQL MIN and MAX Functions: Find Smallest and Largest Values
SQL MIN and MAX tutorial: find the lowest and highest values in a column, use them with WHERE and GROUP BY, get the full row with a subquery, plus NULL rules.