/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

8 votes145 views1 answer
Sql remove leading spaces
SQL
0 vote148 views1 answer
Sql requete number pair
SQL
1 vote140 views1 answer
Psql show with user is logged in
SQL
1 vote177 views3 answers
How to update column name in psql
SQL
1 vote138 views2 answers
Mysql show views
SQL
11 votes197 views2 answers
You are using safe update mode
SQL
0 vote148 views1 answer
SqlFunction does not exist
SQL
4 votes152 views1 answer
Group by mysql and concatenate string
SQL
0 vote151 views1 answer
Sql select all records from all tables where not empty
SQL
0 vote137 views1 answer
Postrgres trunc
SQL