Index
Symbols
- != (inequality) operator, Using WHERE on Numbers, Appendix A3 – Comparison Operators
- % (percent sign)
- modulus operator, AND, OR, and IN Statements
- wildcard character, Using WHERE on Text
- ' ' (quotation marks, single), enclosing literals, Using WHERE on Text
- () (parentheses), grouping with, Grouping Conditions
- ; (semicolon), ending SQL statements, Retrieving Data with SQL
- < (less than) operator, AND, OR, and IN Statements, Appendix A3 – Comparison Operators
- <= (less than or equal to) operator, AND, OR, and IN Statements, Grouping Conditions, Appendix A3 – Comparison Operators
- <> (inequality) operator, Using WHERE on Numbers, Appendix A3 – Comparison Operators
- = (equals) sign
- = (equals) operator, Using WHERE on Numbers, Using WHERE on Text
- = and == operators, Appendix A3 – Comparison Operators
- > (greater than) operator, AND, OR, and IN Statements, Grouping Conditions, Appendix A3 – Comparison Operators
- >= (greater than or equal to) operator, AND, OR, and IN Statements, Appendix A3 – Comparison Operators
- _ (underscore)
- in SQL names, Expressions in SELECT Statements
- wildcard character, Using WHERE on Text
- || (concatenation) operator, Text Concatenation, APPENDIX A5 – Text Operators
A
- Access, Lightweight Databases
- aggregate functions, Aggregate Functions-The HAVING Statement, APPENDIX A7 – Aggregate Functions
- null values and, Aggregate Functions
- aggregating data, GROUP BY and ORDER BY
- filtering different aggregate values using zero/null CASE trick, The “Zero/Null” CASE Trick
- filtering out records ...
Get Getting Started with SQL 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.