ABS and MOD functions in SQL - Step-by-Step Execution

Concept Flow - ABS and MOD functions

Input number

↓

ABS

↓

Output result

The flow starts with an input number, then chooses ABS or MOD function. ABS returns the absolute value, MOD returns the remainder of division, then outputs the result.

Execution Sample

SQL

SELECT ABS(-7) AS abs_val, MOD(17, 5) AS mod_val;

This query calculates the absolute value of -7 and the remainder when 17 is divided by 5.

Execution Table

Step	Function	Input	Calculation	Result
1	ABS	-7	Absolute value of -7	7
2	MOD	17, 5	17 divided by 5 is 3 remainder 2	2
3	END	-	-	-

💡 All functions processed, query returns results.

Variable Tracker

Variable	Start	After ABS	After MOD	Final
abs_val	NULL	7	7	7
mod_val	NULL	NULL	2	2

Key Moments - 2 Insights

Why does ABS(-7) return 7 instead of -7?

ABS returns the positive distance from zero, so it converts negative numbers to positive. See execution_table row 1 where ABS(-7) calculates absolute value 7.

What does MOD(17, 5) return and why?

MOD returns the remainder after division. 17 divided by 5 is 3 with remainder 2, so MOD(17,5) returns 2 as shown in execution_table row 2.

Visual Quiz - 3 Questions

Look at the execution table, what is the result of ABS(-7) at step 1?

A 0

B -7

C 7

D NULL

💡 Hint

Check the 'Result' column in execution_table row 1.

At which step does the MOD function calculate the remainder?

A Step 2

B Step 1

C Step 3

D No step

💡 Hint

Look at the 'Function' column in execution_table to find MOD.

If MOD(17, 5) was changed to MOD(20, 6), what would be the new result?

A 2

B 4

C 3

D 5

💡 Hint

Calculate remainder of 20 divided by 6; check how MOD works in execution_table row 2.

Concept Snapshot

ABS(number): Returns the absolute (positive) value of number.
MOD(number, divisor): Returns remainder after dividing number by divisor.
Use ABS to remove negative sign.
Use MOD to find leftover after division.
Both return numeric results.
Example: ABS(-7)=7, MOD(17,5)=2.

Full Transcript

This visual execution shows how ABS and MOD functions work in SQL. ABS takes a number and returns its absolute value, turning negatives into positives. MOD takes two numbers and returns the remainder after dividing the first by the second. The example query SELECT ABS(-7), MOD(17,5) returns 7 and 2 respectively. Step-by-step, ABS(-7) calculates absolute value 7, MOD(17,5) calculates remainder 2. Variables abs_val and mod_val track these results. Common confusions include why ABS returns positive and how MOD calculates remainder. The quiz tests understanding of these steps and results.