Home
About
Disclaimer
Terms & Conditions
Contact
Universal Info वेलकम
Universal Info वेलकम
Home
Main Menu
Add New Post
Author request
Home
Main Menu
How to get the return value from a dynamic SQL Stored Procedure executed with sp_executesql
October 12, 2018
Procedure expects parameter '@statement' of type 'ntext/nchar/nvarchar'.
October 12, 2018
Error establishing a database connection in WordPress
September 15, 2018
Sql server get restore datetime | restore history sql server
August 11, 2018
Add New Post
Author request
Home
Mysql
MySQL ROUND() function|Mysql Format number to 2 decimal places|Show two decimal places in particular column.
MySQL ROUND() function|Mysql Format number to 2 decimal places|Show two decimal places in particular column.
Blog Admin
January 03, 2018
Try round function:
Syntax:
ROUND(number, decimal_places);
Name Description
N - A number which will be rounded upto D decimal places.
D - A number indicating up to how many decimal places N will be rounded.
Normal Query:
SELECT '786.6579'
Result:
Rounded Query:
SELECT round('786.6579',2)
Result:
Post a Comment
0 Comments
Shop Now
Rs.0.00
Social Plugin
Popular Posts
Annur Bus Stand Bus Timings
June 14, 2017
Annur Encyclopedia
June 14, 2017
Punjai puliampatti bus stand bus timings
August 24, 2018
Android
Audio stops playing after 10 or 15 minutes for local music files
August 10, 2019
how to make Android apps using Visual Studio
February 22, 2019
Fortnite android download | Fortnite on android
November 08, 2018
Categories
Android
4
C sharp
1
Chrome
1
IIS
1
Interface
6
Linq
1
Linux
8
Mysql
175
Mysqldump
9
Network
4
PhpmyAdmin
3
Smart Card
1
Sql
78
tally
2
Visual Studio
14
by
TemplatesYard
Tags
Aadhar
About
affiliate
Agri Eb Line
ajax
Android
asp.net
asp.net core
Bank API
Basic
blogger
Bus Timings
C sharp
c#
calories
CCTV
Chrome
Complaints
contact Us
covid 19
Credit card
CSS
Daily Update
Dam
Decryption
Devexpress
E news paper
Encryption
Excel
ftp
General
GitHub
Gmail
Hindi e newspaper
Holidays
Hospital
Html
IIS
Interface
Java Script
Linq
Linux
mobile App
Mobile Network
Mysql
Mysqldump
Network
Old indian Photos
online payment
Pan Card
PhpmyAdmin
Smart Card
Software testing
Sql
SSL
stock Market
Stock Market Holidays
tally
tamil e newspaper
tasmac
TNeservices
Top 50 websites
Train
vb.net
Visual Studio
website
Windows
WordPress
0 Comments