/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 vote212 views1 answer
Https://livesql.oracle.com/apex/livesql/s/l8fedwph53gt5gigbacwvu6m0
SQL
0 vote178 views1 answer
Oracle execute package dblink
SQL
1 vote192 views1 answer
How to install mysql 8.0 windows service
SQL
1 vote203 views1 answer
Sql select whole row max column
SQL
0 vote212 views1 answer
Apache Derby: Create SQL Dump with data
SQL
0 vote209 views1 answer
Tsql delete all rows
SQL
0 vote335 views1 answer
Get first match in each group mysql query
SQL
0 vote157 views2 answers
Postgresql could not start server mac
SQL
0 vote177 views1 answer
Mysql events not work
SQL
0 vote208 views1 answer
Authentication modes in sql server
SQL