/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

2 votes348 views5 answers
Unique in sql server
SQL
0 vote175 views1 answer
SQL loop with cursor
SQL
22 votes173 views4 answers
Show list of users in mysql
SQL
19 votes189 views6 answers
Sql create table
SQL
31 votes186 views3 answers
SQL Server change column data type
SQL
0 vote174 views1 answer
Change permission to database mysql
SQL
0 vote194 views1 answer
Mysql pv progres
SQL
0 vote342 views1 answer
Current month transactions in mysql
SQL
1 vote184 views1 answer
GROUP BY clause; this is incompati
SQL
0 vote177 views1 answer
Pgsql is not permitted to log in
SQL