➤ 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

Day 5 Today, I used some math functions(ABS, CEIL, FLOOR, SQRT, etc) within my queries to perform data transformation tasks. I also learnt how to write more complex queries with nested functions. #Day5 #30DaysOfSQL #SQL #MathFunctions #NestedFunctions #Data

in #Python, #Decorators are functions that wrap around your existing functions. You have a function and you want to add some functionality to it. You can switch on/off the new features! #nestedfunctions #pythonlearning #pythoncode

Day 05: - Practising more on NullableSafeCalls, ElvisOperator, NestedFunctions, Kotlin Unit Repo: github.com/HemanshuVarma/Kot… #100DaysOfCode #AndroidDev #Kotlin #Android

I learned #functions and some related issues to it like: #ArgumentLabels, #VariadicParameters, #InOutParameters and #NestedFunctions. @CodeToInspire #AfghanGirlsCode #Swift

Inner functions - what are they good for?realpython.com/blog/python/i… #python #closure #nestedfunctions #innerfunctions #decorators