MOD

= //**MOD**// =

** //__Function Arguments: __// **
===MOD(1600/300)100 remainder SELECT last_name, salary, MOD(salary,2) As "Mod Demo"FROM f_staffsWHERE staff_type IN('Order Taker','Cook','Manager'); ===

**//__Description:__// **
MOD: Used to return the remainder when one number is divided by another.

WHERE staff_type IN('Order Taker','Cook','Manager');

 * ~ LAST_NAME

||~ SALARY

||~ Mod Demo

||
 * Doe

|| <span style="color: #000000; font-family: 'Courier New', Courier, monospace;">6.75

|| <span style="font-family: 'Courier New', Courier, monospace;"><span style="color: #000000; font-family: 'Courier New', Courier, monospace;">.75

||
 * <span style="font-family: 'Courier New', Courier, monospace;"><span style="color: #000000; font-family: 'Courier New', Courier, monospace;">Miller

|| <span style="font-family: 'Courier New', Courier, monospace;"><span style="color: #000000; font-family: 'Courier New', Courier, monospace;">10

|| <span style="font-family: 'Courier New', Courier, monospace;"><span style="color: #000000; font-family: 'Courier New', Courier, monospace;">0

||
 * <span style="font-family: 'Courier New', Courier, monospace;"><span style="color: #000000; font-family: 'Courier New', Courier, monospace;">Tuttle

|| <span style="font-family: 'Courier New', Courier, monospace;"><span style="color: #000000; font-family: 'Courier New', Courier, monospace;">60

|| <span style="font-family: 'Courier New', Courier, monospace;"><span style="color: #000000; font-family: 'Courier New', Courier, monospace;">0

||

<span style="font-family: 'Courier New', Courier, monospace;">WHERE staff_type IN('Order Taker','Chef','Manager');
<span style="color: #000000; font-family: 'Courier New', Courier, monospace;">
 * ~ <span style="font-family: 'Courier New', Courier, monospace;"><span style="color: #000000; font-family: 'Courier New', Courier, monospace;">LAST_NAME

||~ <span style="font-family: 'Courier New', Courier, monospace;"><span style="color: #000000; font-family: 'Courier New', Courier, monospace;">FIRST_NAME

||~ <span style="font-family: 'Courier New', Courier, monospace;"><span style="color: #000000; font-family: 'Courier New', Courier, monospace;">SALARY

||~ <span style="font-family: 'Courier New', Courier, monospace;"><span style="color: #000000; font-family: 'Courier New', Courier, monospace;">Mod Demo

||
 * <span style="font-family: 'Courier New', Courier, monospace;"><span style="color: #000000; font-family: 'Courier New', Courier, monospace;">Doe

|| <span style="font-family: 'Courier New', Courier, monospace;"><span style="color: #000000; font-family: 'Courier New', Courier, monospace;">Sue

|| <span style="font-family: 'Courier New', Courier, monospace;"><span style="color: #000000; font-family: 'Courier New', Courier, monospace;">6.75

|| <span style="font-family: 'Courier New', Courier, monospace;"><span style="color: #000000; font-family: 'Courier New', Courier, monospace;">.75

||
 * <span style="font-family: 'Courier New', Courier, monospace;"><span style="color: #000000; font-family: 'Courier New', Courier, monospace;">Tuttle

|| <span style="font-family: 'Courier New', Courier, monospace;"><span style="color: #000000; font-family: 'Courier New', Courier, monospace;">Monique

|| <span style="font-family: 'Courier New', Courier, monospace;"><span style="color: #000000; font-family: 'Courier New', Courier, monospace;">60

|| <span style="font-family: 'Courier New', Courier, monospace;"><span style="color: #000000; font-family: 'Courier New', Courier, monospace;">0

||

<span style="font-family: 'Courier New', Courier, monospace;">
===|| <span style="font-family: 'Courier New', Courier, monospace;">FIRST_NAME || <span style="font-family: 'Courier New', Courier, monospace;">SALARY || <span style="font-family: 'Courier New', Courier, monospace;">MOD DEMO || || <span style="font-family: 'Courier New', Courier, monospace;">Sue || <span style="font-family: 'Courier New', Courier, monospace;">6.75 || <span style="font-family: 'Courier New', Courier, monospace;">.75 || || <span style="font-family: 'Courier New', Courier, monospace;">Bob || <span style="font-family: 'Courier New', Courier, monospace;">10 || <span style="font-family: 'Courier New', Courier, monospace;">0 || || <span style="font-family: 'Courier New', Courier, monospace;">Monique || <span style="font-family: 'Courier New', Courier, monospace;">60 || <span style="font-family: 'Courier New', Courier, monospace;">0 || <span style="font-family: 'Courier New', Courier, monospace;"> ===