Index
Symbols
* (asterisk), 195
|| (concatenation operator), 138
<= (greater than or equal to), 186
>= (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 (value expression), 448–449
COUNT(*), 446
counting all the rows, 446–448
finding ...
Get SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL, 4th 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.