Query Fundamentals
Query Fundamentals Describes the main clauses used in the SELECT, INSERT, DELETE, and UPDATE statements:
Using the SELECT List
Using the FROM Clause
Filtering Rows with WHERE and HAVING
Sorting Rows with ORDER BY
Join Fundamentals
SubQueries
A subquery is a SELECT query that returns a single value and is nested inside a SELECT, INSERT, UPDATE, or DELETE statement, or inside another subquery.
