Remember

Register

Courses Ask a Question

Questions
Unanswered
Ask a Question
Blog
Tutorials
Interview Questions

Back

Login Sign Up Explore Courses Blog Tutorials Interview Questions

community
SQL
Write a number with two decimal places SQL server

Write a number with two decimal places SQL server

Write a number with two decimal places SQL server

0 votes

1 view

asked Jul 18, 2019 in SQL by Tech4ever (20.3k points)

How do you write a number with two decimal places for sql server?

sql
sql-server
decimal
number-formatting

Please log in or register to add a comment.

Please log in or register to answer this question.

1 Answer

0 votes

answered Jul 18, 2019 by Soni Kumari (40.4k points)

Try the below code:

SELECT CONVERT(DECIMAL(10,2),YOURCOLUMN)

Please log in or register to add a comment.

Related questions

0 votes

1 answer

How to store decimal values in SQL Server?

asked Jul 5, 2019 in SQL by Tech4ever (20.3k points)

sql
sql-server
types
decimal

0 votes

1 answer

How to round up to 2 decimal places in java?

asked Oct 23, 2019 in Java by Anvi (10.2k points)

java
java-faq
javascript
rounding
decimal

0 votes

1 answer

Round to at most 2 decimal places (only if necessary)

asked Aug 10, 2019 in Web Technology by Sammy (47.6k points)

javascript
decimal
rounding

0 votes

1 answer

How do I interpret precision and scale of a number in a database?

asked Jul 9, 2019 in SQL by Tech4ever (20.3k points)

sql
database
decimal
scale
precision

0 votes

1 answer

How to write UPDATE SQL with Table alias in SQL Server 2008?

asked Jul 11, 2019 in SQL by Tech4ever (20.3k points)

sql
sql-server
sql-server-2008
sql-update
alias

Welcome to Intellipaat Community. Get your technical queries answered by top developers!

28.4k questions

29.7k answers

500 comments

94.1k users

All categories
Python (3.4k)
Java (2.3k)
SQL (1.6k)
Linux (369)
Big Data Hadoop & Spark (1.2k)
Data Science (2.8k)
R Programming (862)
C Programming (34)
DevOps and Agile (2.9k)
Docker (55)
AI and Deep Learning (1.3k)
Machine Learning (1.1k)
AWS (2.3k)
Azure (1.4k)
GCP (208)
RPA (625)
Selenium (177)
Software Testing (12)
Blockchain (408)
Salesforce (743)
Others (83)
BI (1.8k)
IoT (24)
Web Technology (1.5k)
Cyber Security (314)
Digital Marketing (242)
Technology Trends (96)
SEO (105)
Informatica (15)

Popular Questions

Are Intellipaat course good? Oct 12
What skills does a Data Scientist need? Oct 11
What are the 4 types of AI? Oct 11
How do I prepare big data analytics? Oct 8
How do I learn Salesforce? Oct 8
How do I start learning Big Data? Oct 8

Browse Categories

Master Program
Big Data
Data Science
Business Intelligence
Salesforce
Cloud Computing
Mobile Development
Digital Marketing
Database
Programming
Testing
Project Management
Website Development

Post Graduate Programs

Certification in Digital Marketing | Certification in Big Data Analytics | Certification in Cloud & Devops | Certification in Full Stack Web Development

Popular Master Courses

Big Data and Data Science Master’s Course | Data Science Architect Master’s Program | Cloud and DevOps Architect Master’s Course | Artificial Intelligence Engineer Master’s Course | Microsoft Azure Certification Master’s Training

Popular Courses

Data Science Course Online | Big Data Hadoop Certification Training | Machine Learning Course Online | Artificial Intelligence Course and Training | Salesforce Certification Training: Administrator and App Builder | Tableau Training and Certification Course | Python Data Science Course & Training | Ethical Hacking Course | Business Analyst Course | Courses in Cyber Security

© COPYRIGHT 2011-2021 INTELLIPAAT.COM. ALL RIGHTS RESERVED.

Download Salary Trends Now !

Learn how professionals like you got up to 100% Salary Hike.

...