/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 vote104 views1 answer
Hibernate show sql xml property
SQL
11 votes97 views1 answer
Oracle insert into where
SQL
5 votes95 views2 answers
Oracle list columns schema
SQL
0 vote58 views1 answer
Mssql view column data type
SQL
0 vote105 views2 answers
Postgresql get last day of month
SQL
0 vote114 views1 answer
Get the First and Last Word from a String or Sentence
SQL
1 vote103 views2 answers
Oracle create synonym
SQL
22 votes110 views3 answers
How to join three tables in sql using joins
SQL
0 vote120 views3 answers
Mysqli count down
SQL
0 vote114 views1 answer
Alter rename command in mysql
SQL