Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


Explain the difference between FLOAT, DOUBLE and REAL.

Answers were Sorted based on User's Feedback



Explain the difference between FLOAT, DOUBLE and REAL...

Answer / amith

FLOATs store floating point numbers with 8 place accuracy
and take up 4 bytes.
DOUBLEs store floating point numbers with 16 place accuracy
and take up 8 bytes.
REAL is a synonym of FLOAT for now.

Is This Answer Correct ?    191 Yes 37 No

Explain the difference between FLOAT, DOUBLE and REAL...

Answer / gurmeet singh

A variable of type float only has 7 digits of precision
where as a variable of type double has 15 digits of
precision. If you need better accuracy, use double instead
of float.

Is This Answer Correct ?    38 Yes 4 No

Explain the difference between FLOAT, DOUBLE and REAL...

Answer / baba

This is quite a screwed up forum.. All nuckle heads
shitting on the forum..!!!

Is This Answer Correct ?    15 Yes 7 No

Explain the difference between FLOAT, DOUBLE and REAL...

Answer / mohamad nazim

double has 64 bit- show 8 digith after decimal point
float has 32 bit- show 4 digit after decimal point

Is This Answer Correct ?    13 Yes 6 No

Explain the difference between FLOAT, DOUBLE and REAL...

Answer / mastan

Float has 4 bytes it display 8 places accuracy and double
has 8 bytes it displays 16 places accuracy.

Is This Answer Correct ?    7 Yes 6 No

Explain the difference between FLOAT, DOUBLE and REAL...

Answer / vibhor

float has 32 bit- show 4 digit after decimal point
double has 64 bit- show 8 digith after decimal point
In short, The float is 32 bit while the double is 64 bit
I prepare job's paper from http://quizplaza.com

Is This Answer Correct ?    1 Yes 0 No

Explain the difference between FLOAT, DOUBLE and REAL...

Answer / brianmanee

The Decimal, Double, and Float variable types are different
in the way that they store the values. Precision is the
main difference where float is a single precision (32 bit)
floating point data type, double is a double precision (64
bit) floating point data type and decimal is a 128-bit
floating point data type.

More info... http://net-informations.com/q/faq/float.html

Brian

Is This Answer Correct ?    1 Yes 0 No

Explain the difference between FLOAT, DOUBLE and REAL...

Answer / leelu

float is float (4bytes)

double is double of float ;) (8 bytes) !!

Is This Answer Correct ?    52 Yes 52 No

Explain the difference between FLOAT, DOUBLE and REAL...

Answer / sanah

In Computer Science terminology(world) Real numbers are those which have decimal points.
These real numbers are categorized in 2 ways.
1.Float and
2.Double

Memory used by these two differs based on the programming language on which we works.
For Example in C:-
Float:-It uses only 4 bytes of memory
Double:-It uses 8 bytes of memory
The only difference between these two is that---
Float can hold only 4 bytes(ex:2.4509)
Double is used to hold 8 bytes(ex:2.450877777777777777779)
i.e
if(real_no is larger)
{
we go for double;//remember double is a real
}
else
{
we go for float;//remember float is also a real
}

Is This Answer Correct ?    0 Yes 0 No

Explain the difference between FLOAT, DOUBLE and REAL...

Answer / latha

float is a data type which stores floating values after
the .it takes maximum of 10 bis and it has 4bytes of memory
but in the double it has 8 bytes of memory nd it stores 15
digits after the .(point).

Is This Answer Correct ?    2 Yes 5 No

Post New Answer



More MySQL Interview Questions

What is csv?

0 Answers  


What is timestamp in mysql?

0 Answers  


What language is mysql written in?

0 Answers  


Why should I learn mysql?

0 Answers  


mysql> select * from store; +------+-------+-------+ | id | month | sales | +------+-------+-------+ | 1 | 1 | 100 | | 1 | 2 | 100 | | 1 | 3 | 200 | | 1 | 4 | 300 | | 1 | 5 | NULL | | 1 | 6 | 200 | | 1 | 7 | 800 | | 1 | 8 | 100 | | 1 | 9 | 240 | | 1 | 10 | 140 | | 1 | 11 | 400 | | 1 | 12 | 300 | | 2 | 1 | 300 | | 2 | 2 | 300 | | 2 | 3 | 300 | | 2 | 4 | 200 | | 2 | 5 | 200 | | 2 | 6 | 200 | | 2 | 7 | 100 | | 2 | 8 | 100 | | 2 | 9 | 300 | | 2 | 10 | 100 | | 2 | 11 | 150 | | 2 | 12 | 150 | +------+-------+-------+ this is my table. i need to display output like this. +------+----------+----------+----------+----------+ | id | quarter1 | quarter2 | quarter3 | quarter4 | +------+----------+----------+----------+----------+ | 1 | 400 | 500 | 1140 | 840 | | 2 | 900 | 600 | 500 | 400 | +------+----------+----------+----------+----------+ what single query i have to write for this. i tried this query and it displays like the below mysql> select id,sum(sales) as quarter1,(select sum(sales) from store where mont h>3 and month<7 ) as quarter2,(select sum(sales) from store where month>6 and mo nth<10)as quarter3 from store where month>0 and month<4 group by id; +------+----------+----------+----------+ | id | quarter1 | quarter2 | quarter3 | +------+----------+----------+----------+ | 1 | 400 | 1100 | 1640 | | 2 | 900 | 1100 | 1640 | +------+----------+----------+----------+ 2 rows in set (0.00 sec) tel me how to rectify it.

2 Answers  






How do I get a list of table names in mysql?

0 Answers  


What is mysql used for?

0 Answers  


What is the difference between mysql_fetch_array() and ysql_fetch_object() ?

0 Answers  


What is the difference between BLOB AND TEXT?

0 Answers  


What is the maximum size of table in mysql?

0 Answers  


Is number a datatype in mysql?

0 Answers  


how we can use more then one primary key in Single Table

9 Answers   Systematix,






Categories