/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

3 votes161 views1 answer
Oracle failed login attempts
SQL
0 vote183 views1 answer
What alter does in db
SQL
2 votes176 views1 answer
Get first 2 letter in sql
SQL
0 vote197 views1 answer
Sql doesn't contain
SQL
0 vote183 views1 answer
Sql not exists
SQL
-1 vote184 views1 answer
Sql oracle take only last results
SQL
5 votes183 views1 answer
Oracle ORA-00054 origin
SQL
1 vote256 views1 answer
Error cs1061 'dbcontextoptionsbuilder' does not contain a definition for 'usesqlserver'
SQL
1 vote215 views1 answer
Oracle list data files
SQL
2 votes191 views1 answer
Enum in SQL Server
SQL