/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 vote350 views1 answer
How to change mysql root password in windows 10
SQL
3 votes336 views3 answers
Raw select laravel
SQL
6 votes309 views1 answer
What is where clause in sql
SQL
1 vote315 views2 answers
Check if word is in column sql
SQL
1 vote325 views2 answers
Pad zero sql server
SQL
1 vote358 views1 answer
Oracle transaction rollback not working
SQL
1 vote326 views1 answer
Spark sql concatenate string and int
SQL
1 vote319 views1 answer
Duplicating a MySQL table with all the data Command
SQL
28 votes337 views6 answers
Foreign key
SQL
0 vote320 views1 answer
Select multiple row from primary key sql
SQL