Sql

SELECT ROUND(20.555, 1);
-- 20.5
SELECT ROUND(20.5, 0);
-- 21

round(column)

PREVIOUS	NEXT

Code Example
Sql :: float precision in psql
Sql :: sql server sleep
Sql :: oracle difference between two dates in seconds
Sql :: calculate age in sql postgresql
Sql :: oracle replace
Sql :: get server date mysql
Sql :: Write a query to create an empty table from an existing table?
Sql :: mysql get year from date
Sql :: (PDOException(code: 2002): SQLSTATE[HY000] [2002] Permission denied at
Sql :: give a column name to values generated from case statement in sql
Sql :: update mongodb version ubuntu
Sql :: count mysql
Sql :: oracle insert or update
Sql :: psql get table data types
Sql :: display 2 numbers after decimal mysql
Sql :: postgresql create query
Sql :: sparql list all graphs
Sql :: oracle apex debug mode
Sql :: Get monday of week date is in SQL
Sql :: postgresql distinct
Sql :: select last row mysql
Sql :: join in update query in mysql
Sql :: oracle list dates without weekends
Sql :: postgre sql create table
Sql :: mysql milliseconds
Sql :: sql change a colum to unique
Sql :: varchar vs nvarchar sql
Sql :: linq join
Sql :: oracle difference between two dates in years
Sql :: mysql update column to be nullable