Notes / Dbms / 02 Sql Mastery / 2 Querying Data

2 — Querying Data

Covers the fundamental query clauses — SELECT, WHERE, ORDER BY, LIMIT, DISTINCT, LIKE, IN, BETWEEN, and CASE expressions.

· §202607241142-9 ·
dbmssqlbook
Chapter Navigation
On This Page

2 — Querying Data

Purpose

[stub: querying-data]

Metadata

AuthorAmit Singh
Scopedbms

Local graph

Full graph →

Related notes

3 — Joins

Compares inner, left, right, full, self, cross, anti, and semi joins and how each changes a query's result set.

4 — Aggregation

Covers GROUP BY, HAVING, aggregate functions, and multi-dimensional aggregation via ROLLUP, CUBE, and GROUPING SETS.

5 — Subqueries

Covers scalar and correlated subqueries and the EXISTS, NOT EXISTS, ANY, and ALL predicates.

6 — Common Table Expressions

Covers recursive and non-recursive common table expressions and their use in querying hierarchical data.
← All notes
Dbms notes Edit on GitHub
Next → 3 — Joins