/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 vote125 views1 answer
Php get closest location by latitude longitude
SQL
2 votes162 views3 answers
Xampp mysql database not starting
SQL
0 vote116 views1 answer
What is metadata in sql
SQL
1 vote124 views1 answer
How to select rows with no matching entry in another table?
SQL
0 vote153 views1 answer
Sql count matching group by
SQL
0 vote117 views1 answer
How to to get current date in sql
SQL
62 votes154 views8 answers
Mysql add column
SQL
0 vote119 views1 answer
Mysql shell set time_zone
SQL
0 vote110 views1 answer
Sqlcmd xml output insert line break after every 2033 characters
SQL
0 vote199 views1 answer
Drop check command
SQL