Getting Started with SQL

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 ...