SQL Queries for Mere Mortals®: A Hands-On Guide to Data Manipulation in SQL, Third Edition

Index

acronyms, naming fields, 24

Actian, 60

agents, 53

aggregate functions, 420-422

COUNT, 422-425

filters, 432, 434

Null values, 451

sample statements, 435

bowling league database, 439-440

entertainment agency database, 437

recipes database, 441-442

sales orders database, 435-436

school scheduling database, 438

subqueries as columns, 381-383

using multiple functions, 431-432

aliases, assigning to tables, 258-260

ALL, predicate keywords for subqueries, 392-395

American National Standards Institute (ANSI), 61

analytical databases, 4

AND, 185, 190

sets, 594-595

ANSI (American National Standards Institute), 61

ANSI/ISO standard, 62-65

ANY, predicate keywords for subqueries, 392-395

approximate ...

Get SQL Queries for Mere Mortals®: A Hands-On Guide to Data Manipulation in SQL, Third Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.