/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 vote142 views1 answer
Dump only schema
SQL
0 vote170 views2 answers
Mysql insert into multiple tables
SQL
4 votes150 views1 answer
Create db table
SQL
0 vote158 views1 answer
Implicit inner join table alias with id values
SQL
0 vote164 views1 answer
Php get closest location by latitude longitude
SQL
0 vote199 views1 answer
Id INT NOT NULL AUTO_INCREMENT
SQL
0 vote151 views1 answer
Difference between varchar and varchar2
SQL
2 votes194 views1 answer
Oracle insert or update
SQL
0 vote185 views1 answer
Sql describe
SQL
5 votes146 views2 answers
Umgebungsvariable setzen für mysql 8
SQL