Adding Latest R Version to Jupyter Notebook
Adding Latest R Version to Jupyter Notebook
Pohnson
source() function
Let’s save time!
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
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