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

Index

Symbols

* (asterisk), 195

|| (concatenation operator), 138

< (greater than), 186–188

<= (greater than or equal to), 186

> (less than), 186–188

>= (less than or equal to), 186

() (parentheses), 144, 210–211, 216

CASE (conditional expressions), 684

% (percent sign), 195

? (question mark), 195

_ (underscore), 195

Numbers

2016 SQL Standard, 4

A

ABS, 142

Access, CASE (conditional expressions), 684

Actian, 74

adding sorting specifications to UNION, 382

aggregate expressions, 445

aggregate functions, 444–446, 798–799

AVG, calculating mean values, 451–452

Bowling League Database, 844–846

COUNT, 406–408, 446

COUNT (value expression), 448–449

COUNT(*), 446

counting all the rows, 446–448

in filters, 457–459

grouping data, 477–478

MAX, 406–408

finding ...