/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 vote142 views1 answer
Mysql regex select
SQL
0 vote125 views1 answer
Date datatype in livesql
SQL
4 votes135 views3 answers
Mysql modify foreign key
SQL
14 votes123 views3 answers
How to add default constraint in mysql
SQL
0 vote129 views1 answer
Work around for mutating problem in Oracle Triggers. Please check it out.
SQL
3 votes135 views1 answer
Flutter sqlite auto incrementing id primary key
SQL
0 vote157 views3 answers
Classement rang mysql 7
SQL
1 vote123 views1 answer
Local sql server
SQL
18 votes134 views3 answers
'Client does not support authentication protocol requested by server; consider upgrading MySQL client', sqlState: '08004',
SQL
1 vote120 views1 answer
Check constraint to check if date greater than todays date
SQL