Search
 
SCRIPT & CODE EXAMPLE
 

SQL

sql limit decimal places

SELECT CAST(ROUND(125.025000, 2) AS NUMERIC(36,2))
returns: 125.03
Comment

PREVIOUS NEXT
Code Example
Sql :: sql where contains 
Sql :: mysql list users 
Sql :: create table sqlite 
Sql :: mysql find missing values 
Sql :: mysql create database with collation 
Sql :: mysql current date 
Sql :: insert value in identity 
Sql :: create new table from existing table with data in sql server 
Sql :: how to add CHECK constraint to a column in postgres 
Sql :: psql connect as user with password 
Sql :: check if record exists mysql 
Sql :: mysql version query 
Sql :: postgres default user 
Sql :: sql server sleep 
Sql :: mysql set value as null 
Sql :: sql count group by 
Sql :: laravel get sql query eloquent with parameters 
Sql :: get primary key of table 
Sql :: mysql grant access to one database 
Sql :: psql get table data types 
Sql :: postgresql find duplicates 
Sql :: mysql case when on date 
Sql :: run sql command line download for windows 10 
Sql :: sql alter type of column 
Sql :: alter schema sql server 
Sql :: mysql regexp_replace remove html tag 
Sql :: sql percentage 
Sql :: postgre sql create table 
Sql :: DATE_SUB postgres 
Sql :: RowDataPacket 
ADD CONTENT
Topic
Content
Source link
Name
8+2 =