/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

1 vote126 views1 answer
Drop primary key oracle
SQL
2 votes115 views1 answer
Sql server check for value in multiple columns
SQL
0 vote115 views1 answer
Shrink database file in sql server
SQL
0 vote121 views1 answer
Get initials name in sql
SQL
0 vote113 views1 answer
Inspecting a column unique/distinct values in SQL
SQL
0 vote121 views1 answer
Incorrect string value: mysql
SQL
1 vote131 views1 answer
Isnull sql server
SQL
0 vote108 views1 answer
Create domain sql
SQL
3 votes119 views1 answer
Postgresql today - 1 year
SQL
0 vote109 views2 answers
Imageview setimageresource null
SQL