KwickClips Databases and SQL · 40 sec · free
What is MOD(17, 5)?
Short answer. 2.
What does a negative digit in ROUND do?
It rounds to tens, hundreds and so on.
Remember
| POWER: m to the power n |
| MOD: remainder |
| ROUND: -2 means hundreds |
Round of twelve eighty four point five with minus two? Power gives two cubed, eight. Mod gives the remainder, two. Minus two rounds to the nearest hundred. Power raises. Mod gives the remainder. Minus two rounds to hundreds.
This clip is from the full lesson: SQL Single Row Functions: Math, Text and Date — 6 minutes, with the tables, the quick answers and the whole lesson in text.
Useful for: CBSE Class 12 Informatics Practices (065), CBSE Class 12 Informatics Practices (065), CBSE Class 12 Informatics Practices (065)
More KwickClips from this lesson
Does MID count from 0?43 sec
What is the difference between MONTH and MONTHNAME?42 sec
Can MONTH(dob) be used in WHERE?38 secVoice-over is AI-generated; the script is written and checked by Kajal Ma'am. Confirm anything you plan around against your official board document. We never ask for a password or an OTP.