/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 vote202 views1 answer
Permission denied postgres \copy csv command line
SQL
2 votes119 views1 answer
Sql select in list
SQL
0 vote179 views1 answer
Default value false mysql
SQL
0 vote168 views1 answer
Install mysql 8 linux
SQL
0 vote220 views1 answer
Download mysql database to excel in android studio
SQL
10 votes187 views3 answers
How to fetch first 5 characters in sql
SQL
0 vote163 views1 answer
Backup and restore of sqlite database from c# -sqlserver
SQL
0 vote233 views1 answer
IS THEre any difference between using default and := in plsql
SQL
0 vote175 views1 answer
Dbms_output sql developer
SQL
0 vote161 views1 answer
Remove default constraint sql server
SQL