Breaking News: Grepper is joining You.com. Read the official announcement!

float in sql

Add Answer

priyanshu bhandari answered on February 25, 2022 Popularity 10/10 Helpfulness 1/10

answer float in sql

related sql float data type

related float data type in sql

float in sql

Comment

-2

#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

Popularity 10/10 Helpfulness 1/10 Language sql

Source: Grepper

Tags: sql

Link to this answer
Share Copy Link

Contributed on Feb 25 2022

priyanshu bhandari

0 Answers Avg Quality 2/10

Closely Related Answers

sql float data type

Comment

CREATE TABLE my_table (
  id INT,
  value FLOAT
);

Popularity 9/10 Helpfulness 2/10 Language sql

Source: Grepper

Link to this answer
Share Copy Link

Contributed on Sep 12 2023

YOU.com

0 Answers Avg Quality 2/10

float data type in sql

Comment

-- Create a table with a column of float data type
CREATE TABLE myTable (
  myFloatColumn FLOAT
);

-- Insert a row with a float value
INSERT INTO myTable (myFloatColumn)
VALUES (1234.56);

-- Select rows where the float value is greater than 1000
SELECT * FROM myTable WHERE myFloatColumn > 1000;

Popularity 9/10 Helpfulness 1/10 Language sql

Source: Grepper

Link to this answer
Share Copy Link

Contributed on Sep 11 2023

YOU.com

0 Answers Avg Quality 2/10

float in sql

Contents

More Related Answers

float in sql

Closely Related Answers

sql float data type

float data type in sql

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.