Question

Predict the output of the following queries: 

i. Select power(5,3); 

ii. Select mod(5,3); 

OR 

Briefly explain the purpose of the following SQL functions: 

i. power() 

ii. mod()

Answer 1

Output: 

i. 125 

ii. 2 

OR 

i. power(): It returns the value of a number raised to the power of another number. 

For example: 

Select power(5,3); 

Output: 125 

ii. mod(): It returns the remainder of a number divided by another number. 

For example: 

Select mod(5,3);

Output: 2