/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

2 votes290 views2 answers
Sql first character
SQL
9 votes273 views2 answers
Oracle all tables in schema
SQL
0 vote270 views1 answer
Save single sql query result boolean spring boot
SQL
1 vote311 views1 answer
T-SQL / AZURE Reseed
SQL
3 votes253 views1 answer
If 0 return null else return query mysql
SQL
5 votes298 views1 answer
Get table columns from sql
SQL
0 vote283 views1 answer
Output table plsql
SQL
0 vote272 views1 answer
Time in sql server
SQL
0 vote289 views2 answers
Laravel: customize or extend notifications - database model
SQL
1 vote261 views2 answers
Get date from datetime postgresql
SQL