Informatics Practices
Related Questions
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 Round(153.669, 2);
- 153.6
- 153.66
- 153.67
- 153.7
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
What will be returned by the given query ?
SELECT month('2020-05-11');
- 5
- 11
- May
- November