Informatics Practices
What will be returned by the given query ?
SELECT Round(153.669, 2);
- 153.6
- 153.66
- 153.67
- 153.7
SQL Queries
1 Like
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.
Answered By
1 Like
Related Questions
Predict the output of the following query :
SELECT LCASE(MONTHNAME('2023-03-05'));- May
- March
- may
- march
To remove the leading and trailing space from data values in a column of MySQL Table, we use
- Left()
- Right()
- Trim()
- Ltrim()
What will be returned by the given query ?
SELECT Sign(26);- 1
- -1
- 0
- none of these
What will returned by the given query ?
SELECT Truncate(15.79, -1), Truncate(15.79, 0), Truncate(15.79, 1);- 15 15 15.7
- 10 15.7 15.9
- 10 15 15.7
- 10 10 15.9