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 |