/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 vote407 views1 answer
Sql find gaps in date ranges
SQL
0 vote342 views2 answers
Postgresql create role
SQL
0 vote400 views1 answer
Dynamic where clause in sql server stored procedure
SQL
12 votes370 views4 answers
How to take database dump in postgresql
SQL
0 vote350 views1 answer
Database timezone
SQL
13 votes354 views5 answers
Select last row mysql
SQL
8 votes369 views1 answer
Oracle create datafile
SQL
1 vote338 views1 answer
MySQL AND Operator
SQL
0 vote378 views1 answer
Illuminate\Database\QueryException SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client (SQL: select * from information_schema.tables where table_schema = blog and table_name = migrations and table_type = 'BASE TABL
SQL
2 votes377 views2 answers
Enable foreign key checks postgres
SQL