SQL Cookbook (Cookbooks (OReilly))

Index

[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [Y] [Z]

names 2nd

negation queries 2nd 3rd

     A only 2nd 3rd 4th

     A or B but not both 2nd 3rd

     not A 2nd 3rd 4th

NEXT_DAY function (Oracle) 2nd 3rd

NOT EXISTS

NOT IN operator

NROWS function (DB2/SQL Server)

NTILE window function (Oracle/SQL Server) 2nd 3rd

NULL paradox 2nd 3rd 4th

NULLs

     aggregate functions and 2nd 3rd

     AVG function and

     comparisons to 2nd

     groups and

     MIN/MAX functions and

     OR operations and

     sorting and 2nd 3rd 4th

     window functions and 2nd

numbers queries

     averages without high/low values

     converting alphanumeric strings to

     converting whole to binary (Oracle)

     counting column values

     counting rows

     nullable columns

     percentage of total 2nd

     percentage relative to total

     subtotals 2nd 3rd 4th

     subtotals for all combinations 2nd 3rd 4th 5th 6th 7th 8th 9th 10th

NVL function (Oracle)