What is the difference between SMALLINT and INTEGER?

1.	What is the difference between SMALLINT and INTEGER?
Answer» The difference is in the RANGE and PRECISION. While the SMALLINT can store the numbers up to a precision of 15 bits with a range of -32768 to +32767, the INTEGER data type can store the numbers up to a precision of 31 bits having the range from -2,147,483,648 to +2147483648. There is also one more data type to store the integer type of data. It is called BIGINT and its range is even higher than INTEGER.

Discussion