/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 vote209 views1 answer
Postgres get month name from date
SQL
0 vote207 views1 answer
How to connect to mysql in ef 6
SQL
0 vote210 views1 answer
How to use query in nosql
SQL
18 votes231 views3 answers
Get the list of all tables in sql server
SQL
1 vote217 views1 answer
Drop df constraint sql server
SQL
0 vote233 views1 answer
Postgres list all stored procedures query
SQL
0 vote218 views1 answer
Copy row from db to db mysql
SQL
1 vote365 views2 answers
Sql unique rows
SQL
0 vote231 views1 answer
R write csv without index
SQL
-1 vote222 views3 answers
My sql alter table
SQL