EXTRACT
CASE Statement
CONCAT
FORMAT while CREATING and SELECTING
NULLIFZERO
SELECT from a table
Converting Decimal type to Char type with leading zeros
COLUMN ALIASING
COUNT and COUNT(Asterik)
Converting DECIMAL to VARCHAR
MINUS
EXCEPT
Forcing CASE SPECIFIC
PRODUCT JOIN
ORDER BY
GROUP BY
HAVING - Retrieval with GROUP BY
SELF JOIN
EXISTS
Converting Columns into Rows
Changing FLOATs to TIMEs
CAST
INNER JOIN
Explicit join condition
EQUI JOIN
NATURAL JOIN
LEFT OUTER JOIN
RIGHT OUTER JOIN
FULL OUTER JOIN
SELF JOIN
IN
OR
BETWEEN
LIKE
Selecting records using QUALIFY
RANK
ROW_NUMBER
Difference ROW_NUMBER Vs RANK functions
Nested Case statement
Concatenation Operator ||
ZEROIFNULL
NOT EXISTS
Convert rows into columns for huge rows
Convert rows into columns
COUNT with GROUP BY
CROSS JOIN
ORDER BY DESC
ORDER BY on two columns
Implicit join condition
EQUI JOIN with USING construct
NOT IN
BETWEEN for DATE types
LIKE with CASE SPECIFIC
LIKE for Range Of Values
LIKE for List Of Values
LIKE with ESCAPE SEQUENCE