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...

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...

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...

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...

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...

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...

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...

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.

Brian

 Is This Answer Correct ? 1 Yes 0 No

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

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...

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...

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

More MySQL Interview Questions

What is csv?

What is timestamp in mysql?

What language is mysql written in?

Why should I learn mysql?

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.

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

What is mysql used for?

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

What is the difference between BLOB AND TEXT?

What is the maximum size of table in mysql?

Is number a datatype in mysql?

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

Categories