/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 vote286 views1 answer
Authentication modes in sql server
SQL
0 vote258 views1 answer
Create or replace view postgress
SQL
1 vote275 views1 answer
How to ckeck that email is present in databse in mysqli
SQL
0 vote258 views1 answer
Sql auto_increment syntax
SQL
0 vote299 views1 answer
Error code 1451 sql
SQL
6 votes281 views2 answers
Non relational database
SQL
7 votes304 views3 answers
Sql update where id
SQL
0 vote252 views1 answer
TITLE: SQL Server principal "dbo" does not exist
SQL
0 vote218 views1 answer
Expose db in virtualbox
SQL
0 vote277 views1 answer
Sql set data from a select query to a temp table and insert
SQL