Core SQL Querying Essentials

Filtering Aggregated Results

SQL Query Building Blocks

Selecting All Columns With The Wildcard

Removing Duplicates With DISTINCT

Comparison Operators

Range Filtering With BETWEEN

Selecting Specific Columns

Set Membership With IN

Pattern Matching With LIKE

Filtering NULL Values

Sorting With ORDER BY

Ascending vs Descending Sort

Sorting By Multiple Columns

Limiting Result Rows

String Literals And Quoting

Negating With NOT

Combining With AND / OR

Logical Order Of Clauses

Filtering With WHERE

Column Aliases With AS

Selecting All Columns

SQL Syntax Basics

Limiting Rows With LIMIT and TOP

Removing Duplicates With DISTINCT

Sorting by Multiple Columns

Ascending and Descending Order

Sorting Results With ORDER BY

Handling NULLs With IS NULL

Set Membership Filtering With IN

Range Filtering With BETWEEN

Pattern Matching With LIKE

Combining Conditions With AND, OR, NOT

SQL Comparison Operators in WHERE

Filtering Rows With WHERE

Renaming Columns With AS Aliases

Specifying Tables With FROM

Filtering Ranges With BETWEEN

Filtering With IN

Pattern Matching With LIKE

Handling NULL Values

Sorting With ORDER BY

Sorting Descending

Sorting By Multiple Columns

Removing Duplicates With DISTINCT

Limiting Returned Rows

Clause Order In A Query

Selecting All Columns

Combining Conditions

Selecting Specific Columns

WHERE Comparison Operator

Column Aliases With AS

Selecting Specific Columns by Name

The SELECT Statement's Purpose

Ascending vs Descending Sort

WHERE Clause for Filtering

IN Operator for Value Lists

Sorting by Multiple Columns

String Literals and Quoting

Case Sensitivity and Conventions

SELECT Statement Basic Syntax

Selecting All Columns with *

FROM Clause and Table Name

SELECT DISTINCT for Unique Values

Comparison Operators

BETWEEN Operator for Ranges

Filtering with IS NULL / IS NOT NULL

Selecting Specific Columns

LIMIT Clause to Restrict Rows

Column Aliases with AS

Logical Operators AND, OR, NOT

LIKE Operator and Wildcards

ORDER BY for Sorting

Statement Termination with Semicolon