/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

24 votes163 views4 answers
Mysql datetime
SQL
2 votes180 views1 answer
Mysql shell insert into
SQL
0 vote146 views2 answers
Pl sql auto increment
SQL
0 vote145 views1 answer
Database xml sql
SQL
0 vote142 views1 answer
Date datatype in livesql
SQL
0 vote182 views1 answer
Ran rails db:migrate and got == 20210620104415 DeviseCreateUsers: migrating ================================ -- create_table(:users) rails aborted! StandardError: An error has occurred, this and all later migrations canceled: SQLite3::SQLE
SQL
1 vote147 views1 answer
How to remove identity from a column in sql server
SQL
0 vote151 views1 answer
Access denied for user 'root'@'localhost' (using password no) stackoverflow
SQL
0 vote156 views1 answer
Sql show founctions
SQL
1 vote138 views1 answer
Sql auto date
SQL