C



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]

calendars
Cartesian products
CAST function (SQL Server)
CEIL function (DB2/MySQL/Oracle/PostgreSQL) 2nd
CEILING function (SQL Server) 2nd
COALESCE function 2nd 3rd 4th 5th
columns
     adding headers to double pivoted result sets
     concatenating
complex
    retrieving records
         non-subtotal rows
         rows
composite subqueries
CONCAT function (MySQL) 2nd 3rd
concatenation
     columns
     operator (+) (SQL Server) 2nd
     operator (||) (DB2/Oracle/PostgreSQL) 2nd
conditional logic in SELECT statements
CONNECT BY clause (Oracle)
     alternatives to
     in hierarchical structures 2nd 3rd
     inline views and
     WITH clause and 2nd
CONNECT_BY_ISLEAF function (Oracle) 2nd
CONNECT_BY_ROOT function (Oracle) 2nd
constraints
     listing
correlated subqueries
COUNT function 2nd 3rd 4th
COUNT OVER window function 2nd
CREATE TABLE … LIKE command (DB2)
CREATE TABLE command
cross-tab reports
     creating (SQL Server)
CSV output 2nd 3rd
CUBE extension 2nd 3rd
CURRENT_DATE function (DB2/MySQL/PostgreSQL) 2nd 3rd




SQL Cookbook
SQL Cookbook (Cookbooks (OReilly))
ISBN: 0596009763
EAN: 2147483647
Year: 2005
Pages: 235

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net