Number data types in SQL

In this chapter you will learn:
What is number data type?
Types of number data type

What is number data type?

The data type which store the value in the form of number, integer, decimal etc. is called number data type. Here you will get some number data types that are used to store different kinds of numeric data in sql.

Data types Range Used to store Storage (Bytes)
int -2,147,483,648 to 2,147,483,647 Integer data (whole numbers) 4
smallint (-32,768) to (32,767) Integer data 2
tinyint 0 to 255 Integer data 1
bigint (-9,223,372,036,854,775,808) to (9,223,372,036,854,775,807) Integer data 8
decimal -10^38 +1 to 10^38 -1 Numeric data types with a fixed precision and scale 5 to 17
numeric -10^38 +1 to 10^38 -1 Numeric data types with a fixed precision and scale 5 to 17
float -1.79E+308 to -2.23E-308, 0 and 2.23E-308 to 1.79E+308 Floating Precision data 4 to 8
money (-922,337,203,685,477.5808) to (922,337,203,685,477.5807) Monetary data 8
smallmoney (-214,748.3648) to (214,748.3647) Monetary data 4
real -3.40E + 38 to 3.40E + 38 Floating precision number 4

SUMMARY

In this chapter we have learned about numeric data types and types of numeric data. In the next chapter we will study about date data type and also we will know about types of date data type.

More Articles

 

Share your thought



PLEASE DISABLE ADBLOCKER AND SUPPORT US!

Please support us by enabling ads on this page. Refresh

YOU DON'T LIKE ADS, WE ALSO DON'T LIKE ADS!
 
But we have to show ads on our site to keep it free and updated. We have to pay huge server costs, domain costs, CDN Costs, Developer Costs, Electricity and Internet Bill. Your little contribution will encourage us to regularly update this site.