Sql

SELECT ROUND(COLUMN_NAME, ROUND_OFF_VALUE) FROM TABLE;

-- SELECT ROUND(VALUE,X) FROM TABLE; To round off value upto x decimal places

-- Oracle
SELECT round( 2.5677, 2) FROM DUAL;

PREVIOUS	NEXT

Code Example
Sql :: upper case sql
Sql :: postgres update with if condition query
Sql :: partition by sql server
Sql :: add time to date sql
Sql :: Converting mysql tables to charset utf8mb4
Sql :: mysql delete rows
Sql :: SQL Less Than or Equal to Operator
Sql :: Create boolean column in MySQL with false as default value?
Sql :: how to select an index in oracle sql
Sql :: mysql datetime with timezone offset
Sql :: postgres update single column
Sql :: mysql limit
Sql :: mysql change value
Sql :: mysql set boolean default value
Sql :: sql server select furst day of current year
Sql :: view table sql
Sql :: subquery in sql
Sql :: sql server split string last
Sql :: postgre insert select
Sql :: unable to convert mysql date/time value to system.datetime
Sql :: mysql biginteger size
Sql :: mysql disable logging
Sql :: exec procedure oracle
Sql :: add column table pl sql
Sql :: postgres sum when
Sql :: How to get last inserted primary key in SQL Server
Sql :: uncheck constraints and delete from table
Sql :: change schema in sql server
Sql :: SQL Remove Primary Key Constraint - MySQL
Sql :: mysql fetch all data