/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 vote344 views1 answer
How to open mysql in docker
SQL
5 votes345 views1 answer
Sql use database
SQL
7 votes356 views1 answer
Oracle pagination query offset
SQL
0 vote352 views4 answers
Postgresql between month
SQL
2 votes368 views2 answers
Mysql alter column default
SQL
3 votes347 views1 answer
Dbms_scheduler drop_job
SQL
1 vote359 views1 answer
Drop column if exists sql server
SQL
1 vote375 views1 answer
How to select all attributes from a row if there is a certain string in it MySQL
SQL
0 vote342 views1 answer
Sqlplus change user
SQL
0 vote340 views1 answer
Sql query interview questions githu
SQL