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]

PARTITION BY clause 2nd 3rd 4th

partitions

     ORDER BY clause and

patterns

     finding non-matching text (Oracle)

percentage calculations 2nd 3rd 4th

PERCENTILE_CONT function (Oracle) 2nd

PIVOT operator (SQL Server) 2nd 3rd

pivoting

     inter-row calculations

     MODEL clause (Oracle)

     multiple rows 2nd 3rd 4th 5th 6th

     one row

     ranked result sets 2nd 3rd 4th 5th

     subtotals 2nd 3rd

PostgreSQL

     PRIOR keyword (Oracle)