➤ Important Rule - Read Inside Out! ROUND(ABS(MOD(-17, 5)), 0) Step 1: MOD(-17, 5) → -2 (innermost) Step 2: ABS(-2) → 2 (next level) Step 3: ROUND(2, 0) → 2 (outermost) Final Output: 2 • Always evaluate innermost first, work outwards! ➤ Quick Summary: • ROUND(n, d) = rounds to d decimal places, negative d rounds to tens/hundreds • TRUNC(n, d) = cuts at d decimal places, no rounding at all • MOD(n, d) = remainder after division, use to find even/odd numbers • ABS(n) = always returns positive value useful for differences • CEIL(n) = always rounds UP even 55.1 becomes 56 • FLOOR(n) = always rounds DOWN even 55.9 becomes 55 • POWER(n, e) = n raised to power e • SQRT(n) = square root • Nested functions = inner executes first, outer uses inner's result • Always read nested functions inside out • Can nest as many levels as needed 2, 3, 4 levels deep all work #OracleSQL #NumericFunctions #ROUND #TRUNC #MOD #NestedFunctions #LearnSQL #SQLBeginners #Day23 #100DaysOfCode #TechTwitter

Explanation on Numeric Functions in R Programming by @Laksh_Salunkhe #numericfunctions #rprogramming #machinelearning #mindsmapped mindsmapped.com/numeric-func…