Informatics Practices
Write the output of the following SQL command :
SELECT Round(49.88);
- 49.88
- 49.8
- 49.0
- 50
SQL Queries
2 Likes
Answer
50
Reason — The ROUND() function rounds the numeric value "49.88" to the nearest whole number, which is 50.
Answered By
3 Likes
Related Questions
What will be returned by the given query ?
SELECT month('2020-05-11');- 5
- 11
- May
- November
Which of the following are correct aggregate functions in SQL ?
- AVERAGE()
- MAX()
- COUNT()
- TOTAL()
Predict the output of the following query :
SELECT MOD(9, 0);- 0
- NULL
- NaN
- 9
The avg() function in MySQL is an example of …………… .
- Math function
- Text function
- Date Function
- Aggregate Function