BETWEEN
COLUMN ALIASING
EXISTS
Forcing CASE SPECIFIC
FORMAT while CREATING and SELECTING
LEFT OUTER JOIN
LIKE
MINUS
NATURAL JOIN
NULLIFZERO
SELF JOIN
SELF JOIN
EQUI JOIN
EXCEPT
FULL OUTER JOIN
Converting DECIMAL to VARCHAR
Converting Decimal type to Char type with leading zeros
COUNT and COUNT(Asterik)
CASE Statement
Changing FLOATs to TIMEs
Selecting records using QUALIFY
Converting Columns into Rows
IN
INNER JOIN
OR
ORDER BY
PRODUCT JOIN
RIGHT OUTER JOIN
CAST
CONCAT
RANK
Difference ROW_NUMBER Vs RANK functions
Explicit join condition
EXTRACT
GROUP BY
HAVING - Retrieval with GROUP BY
ROW_NUMBER
SELECT from a table
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