Informatics Practices
Predict the output of the following query :
SELECT MOD(9, 0);
- 0
- NULL
- NaN
- 9
SQL Queries
2 Likes
Answer
NULL
Reason — The MOD() function returns NULL when the divisor is zero because division by zero is undefined in SQL.
Answered By
3 Likes
Related Questions
Which of the following are correct aggregate functions in SQL ?
- AVERAGE()
- MAX()
- COUNT()
- TOTAL()
Write the output of the following SQL command :
SELECT Round(49.88);- 49.88
- 49.8
- 49.0
- 50
The avg() function in MySQL is an example of …………… .
- Math function
- Text function
- Date Function
- Aggregate Function
An aggregate function performs a calculation on …………… and returns a single value.
- single value
- multiple values
- no value
- none of these