Home >> SQL >> Numeric Data Types in SQL

Numeric Data Types in SQL

The Following numeric data types are-

1)-INT(20 digits)-A large integer that can be signed or unsigned.

signed range from -9223372036854775808 to 9223372036854775807
unsigned range from 0 to 18446744073709551615
->8 Bytes

2)-INT(11 digits)-A normal sized integer that can be signed or unsigned.

signed range from -2147483648 to 2147483647
unsigned range from 0 to 4294967295
->4 Bytes

3)-MEDIUMINT(9 digits)-A medium size integer that can be signed or unsigned.

signed range from -83888608 to 83888607
unsigned range from 0 to 16777215
->3 Bytes

4)-SMALLINT(5 digits)-A small integer that can be signed or unsigned.

signed range from -32768 to 32767
unsigned range from 0 to 65535
->2 Bytes

5)-TINYINT(4 digits)-A very small integer that can be signed or unsigned.

signed range from -128 to 127
unsigned range from 0 to 255
->1 Bytes

6)-MONEY()-

7)-SMALLMONEY()-

Post Your Comment

Next Questions
Floating Data Types
Date and Time Data Types
String Data Types
Enum Data Types
SET Data Types
Difference between varchar and char
Difference between Tinyint and smallint
Difference between enum and set
Difference between signed and unsigned
Operators
Arithmetic Operators
Comparison Operators
Logical Operators
What is key
What is super key
What is candidate key
What is primary key
What is unique key
What is foreign key
What is join
What is cross join
What is natural join
What is outer join
What is self join
What is aggregate function

Copyright ©2022 coderraj.com. All Rights Reserved.