/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 vote230 views1 answer
Is numeric in sql
SQL
8 votes243 views1 answer
Oracle current date plus 1 month
SQL
0 vote236 views1 answer
Sequelize postgresql schema
SQL
0 vote225 views1 answer
Sql create table with datetime automatically
SQL
28 votes194 views6 answers
Distinct sql
SQL
2 votes238 views1 answer
Oracle calculated column
SQL
3 votes250 views3 answers
Mysql declare variable
SQL
0 vote241 views1 answer
View to table sql
SQL
0 vote235 views2 answers
Postgres another version
SQL
1 vote245 views1 answer
How to delete data from sql database in android
SQL