SQL

float in sql

#Float is a data type which stores only decimal value. The difference between integer
#and float is that in an integer the value will be rounded off
#whereas in float the decimal value will be shown as the input.

#for example 3.54 stored in float will give an output of 3.54
#whereas 3.54 sotred in integer data type will give an output of 4

code:
create table salary(name varchar(20), Salary float);


#when inserting values, the need for using ''   is mandatory just like in the case of
#integer