Learning SQL, 3rd Edition

Index

Symbols

• * (asterisk)
  • in aggregate functions, Grouping Concepts, How Nulls Are Handled
  • in select clause, The select Clause
• \ (backslash), as escape character, Including single quotes
• ( ) (parentheses)
  • enclosing subqueries, Derived (subquery-generated) tables
  • grouping arithmetic operations, Working with Numeric Data
  • grouping compound queries, Set Operation Precedence
  • grouping filter conditions, The where Clause, Using Parentheses
• % (percent sign), modulo operator, Performing Arithmetic Functions
• + (plus sign), concatenation operator, SQL Server, Including special characters
  • (see also arithmetic operators)
• ' ' (quotes, single)
  • enclosing strings, String Generation
  • escape sequence for, Including single quotes-Including single quotes
• || (vertical bar, double), concatenation operator, Oracle, Including special characters

A

• abs() function, Handling Signed Data
• acos() function, Performing Arithmetic Functions
• add constraint keywords, Constraint Creation
• add index keywords, Index Creation
• add unique keywords, Unique indexes
• add_months() function, Temporal functions that return dates
• ADO.NET, SQL: A Nonprocedural Language
• aggregate functions, Grouping Concepts-How Nulls Are Handled, Reporting Functions-Window Frames
  • expressions in, Using Expressions
  • filtering based on, Grouping Concepts-Grouping Concepts
  • list of, Aggregate Functions-Aggregate Functions
  • null values with, How Nulls Are Handled-How Nulls Are Handled
• aggregated data, views for, Data Aggregation
• aliases
  • for columns, Column Aliases
  • for tables, Using the Same ...