/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 vote132 views1 answer
TSQL Code Snippet For Optimized Sales Query
SQL
0 vote136 views1 answer
Best sql collation
SQL
5 votes168 views1 answer
Ora-00054 resource busy and acquire with nowait
SQL
0 vote151 views1 answer
Mysql dump for selected row
SQL
0 vote204 views1 answer
Mysql update all record removing 2 hours from column
SQL
11 votes141 views2 answers
MySQL DISTINCT
SQL
0 vote139 views1 answer
How to check replication lag in mySQL
SQL
0 vote133 views1 answer
Sql transact create cursor with dynamic tables
SQL
3 votes149 views1 answer
Sql online test questions and answers
SQL
0 vote134 views1 answer
How to list function in psql
SQL