/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

57 votes602 views6 answers
Mysql alter table add column
SQL
1 vote379 views1 answer
Select users with same username
SQL
1 vote390 views1 answer
How to use db.execute
SQL
1 vote358 views3 answers
Postgresql crete view
SQL
0 vote373 views1 answer
Name '_mysql' is not defined
SQL
17 votes332 views2 answers
How to assign date field for table in mysql
SQL
0 vote347 views1 answer
Sql create table with references not primary key
SQL
0 vote379 views1 answer
Sort by last two number sql
SQL
21 votes375 views6 answers
Change column in mysql
SQL
0 vote386 views2 answers
How to prevent sql injection in java
SQL