Sql

Search

SQL rounding numbers

SELECT 2.555555; --> Result 2.555555
SELECT ROUND(2.555555); --> Result 3
SELECT ROUND(2.555555, 3); --> Result 2.556
SELECT ROUND(2.555555, 0); --> Result 3

Comment

PREVIOUS	NEXT

Code Example
Sql :: wherein mysql
Sql :: find duplicate keys in mysql
Sql :: sql concat string with column value
Sql :: input in mysql
Sql :: how to get the number of columns in a table in sql
Sql :: sql offset
Sql :: sql server: difference between hashtable and table declared using declare keyword
Sql :: update field sql
Sql :: postgres add column integer
Sql :: postgresql cast
Sql :: mysql url
Sql :: get duplicate records in sql
Sql :: oracle sql date get month
Sql :: reseed sql table primary key
Sql :: c# sql select
Sql :: mysql set password for user
Sql :: postgres check for foreign key
Sql :: mariadb alter table add column if not exists example
Sql :: login to mysql database
Sql :: concatenate two strings in sql
Sql :: How to convert DateTime to VarChar SQL
Sql :: run postgres docker
Sql :: sql select last id
Sql :: sql update where id
Sql :: mysql search table in all databases
Sql :: python pandas df to postgres json table
Sql :: mysql copy table to another table
Sql :: eliminate zero from integer mysql
Sql :: if null mysql
Sql :: incompatible sql_mode=only_full_group_by

Search

SQL

SQL rounding numbers

ADD CONTENT