O'Reilly logo

SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL, Fourth edition by John L. Viescas

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Index

Symbols

* (asterisk), 195

|| (concatenation operator), 138

> (greater than), 186188

>= (greater than or equal to), 186

< (less than), 186188

<= (less than or equal to), 186

() (parentheses), 144, 210211, 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, 444446, 798799

AVG, calculating mean values, 451452

Bowling League Database, 844846

COUNT, 406408, 446

COUNT (value expression), 448449

COUNT(*), 446

counting all the rows, 446448

in filters, 457459

grouping data, 477478

MAX, 406408

finding ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required