/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
Sql select most frequent value in column
SQL
1 vote263 views1 answer
How to show index type in postgresql
SQL
4 votes240 views1 answer
How to drop a database in sql server when it is in use
SQL
0 vote180 views1 answer
Cara menampilkan user di mysql terminal
SQL
0 vote218 views4 answers
Forenkey code alchemy sql
SQL
0 vote179 views1 answer
If exist column in table drop sql query mysql
SQL
7 votes202 views5 answers
Oracle alter table
SQL
0 vote197 views5 answers
Mode sql course
SQL
0 vote184 views1 answer
Sql constarint
SQL
0 vote200 views1 answer
Sql xampp gabungan nama awal dan akhir
SQL