UNION and SORT BY
SORT BY is applied at the end. If it is ORACLE, use UNION ALL to apply SORT BY to only one table
SQL
PARSENAME and REPLACE
PARSENAME + REPLACE = Excel’s Text to Column
EOMONTH
EOMONTH
Common Table Expression
CTE
LAG and LEAD
LAG and LEAD
RANK and DENSE_RANK
RANK and DENSE_RANK are helpful. 😀
LEFT and RIGHT
LEFT & RIGHT
SELECT INTO
SELECT INTO
DISTINCT
Distinct Function
CREATE, INSERT, UPDATE, DELETE, and DROP
Basic table manipulation