/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

48 votes416 views3 answers
Psql create database
SQL
1 vote343 views1 answer
Sql server: difference between hashtable and table declared using declare keyword
SQL
0 vote357 views1 answer
Sqlite to csv statement
SQL
1 vote373 views1 answer
Oracle nvl2
SQL
0 vote385 views1 answer
Declare or use variable in snowflake
SQL
0 vote402 views1 answer
Fetching data from mysqldb
SQL
0 vote353 views1 answer
Insert into select with group by
SQL
0 vote344 views2 answers
How to get last inserted id in sql server c#
SQL
0 vote365 views1 answer
Mysql shell ERROR: Not connected.
SQL
5 votes345 views3 answers
Day of week postgresql
SQL