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
Month: April 2018
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