Bright Tutorials Bright Tutorials
CBSE Class 12 Informatics Practices Question 34 of 81

MySQL Functions — Question 16

Back to all questions
16
Question

Question 16

What will be returned by the given query ?

SELECT Round(153.669, 2);
  1. 153.6
  2. 153.66
  3. 153.67
  4. 153.7
Answer

153.67

Reason — The ROUND() function in MySQL is used to round a number to a specified number of decimal places. In this query, ROUND(153.669, 2) rounds the number 153.669 to 2 decimal places, resulting in the output 153.67.