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]

manipulation

    dates

         month

         time units 2nd

MAX function 2nd

MAX OVER window function 2nd 3rd

MEASURES subclause of MODEL clause (Oracle)

MEDIAN function (Oracle)

MERGE statement 2nd

merging records 2nd

metadata

     columns in table

     constraints on table

     data dictionary

     foreign keys without indexes

     generating SQL

     indexed columns in table

     tables in schema

MIN function

MIN OVER window function (DB2/Oracle/SQL Server) 2nd 3rd

minimum values 2nd 3rd 4th

MINUS operation 2nd 3rd

MINUTE function (DB2)

MOD function (DB2)

MODEL clause (Oracle)

     uses

modes

modifying records

     changing row data

     using queries for new values

     when corresponding rows exist

     with values from another table 2nd 3rd 4th

modulus (%) function (SQL Server) 2nd

MONTH function (DB2/MySQL) 2nd 3rd 4th

MONTHNAME function (DB2/MySQL) 2nd

MONTHS_BETWEEN function (Oracle) 2nd

multiple tables

     inserting data into 2nd

     retrieving data from 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th

         comparing 2nd 3rd 4th

         joins when aggregates are used 2nd 3rd 4th 5th

         missing data from multiple tables 2nd

         outer joins when using aggregates 2nd 3rd

         values nonexistant in all tables 2nd 3rd 4th

multisets