/SQL/Select mysql limit to 2 decimal places

Select mysql limit to 2 decimal places

/**
When formatting number to 2 decimal places you have two options TRUNCATE and ROUND.
You are looking for TRUNCATE function.
Examples:
**/

-- Without rounding:
TRUNCATE(0.166, 2)
-- will be evaluated to 0.16

TRUNCATE(0.164, 2)
-- will be evaluated to 0.16
-- docs: http://www.w3resource.com/mysql/mathematical-functions/mysql-truncate-function.php

-- With rounding:
ROUND(0.166, 2)
-- will be evaluated to 0.17

ROUND(0.164, 2)
-- will be evaluated to 0.16
-- docs: http://www.w3resource.com/mysql/mathematical-functions/mysql-round-function.php

Source: stackoverflow.com

Similar codes

0 vote305 views1 answer
Add week ending date sql server
SQL
4 votes266 views2 answers
What is table in sql
SQL
0 vote303 views2 answers
Compound operator in sql
SQL
25 votes280 views6 answers
Sql update query
SQL
0 vote298 views1 answer
How to install sql in anaconda
SQL
0 vote291 views1 answer
Tsql table column constraint must be uppercase
SQL
0 vote264 views2 answers
Change database postgres
SQL
9 votes263 views6 answers
Sql insert into
SQL
0 vote271 views1 answer
Table values functions in SQL
SQL
1 vote259 views1 answer
MYSQL HOT TO COUNT THE DURATION BETWEEN TWO DATES
SQL