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.

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.

Answer / baba

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

Answer / mohamad nazim

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

Answer / mastan

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

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

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

Answer / leelu

float is float (4bytes)

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

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
}

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

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  

all the queries used in sql

0 Answers   TCS,

What are the applications required to support mysql?

0 Answers  

Why do we use the mysql database server?

0 Answers  

What is dump in mysql?

0 Answers  

What is the difference between is null & is not null?

0 Answers  

Write a query to fetch duplicate records from a table using mysql?

0 Answers  

In a property booking section want a query to check that property is booked from StartDate to EndDate.Booking Table field are given id proerty_id start_date checkout_date no_of_visitor booking date status Waiting yours answer.. Thanks In Advance...

1 Answers  

Hi Team, This is kartik, I recently completed my B-tech. Importance of posting this question is for to know the best books on SQL(MYSQL/Oracle)? I like SQL concept's so much, at the same time i decided to choose SQL for my career purpose. So please suggest me the best books that are very helpful for a fresher to improve concepts like (SQL/PLSQL)Basics, programming concepts, architectures etc. Please consider my request as an important one. I am very thankful to you for providing this opportunity. If possible can you please send the names of books for my personal id also: karthikgdv1206@yahoo.com. Thanks, Kartik T

0 Answers  

How we can get the current date in mysql?

0 Answers  

What ascii 31?

0 Answers  

Why do gaps in sequences occur?

0 Answers