Interested to Buy Any Domain ? << Click Here >> for more details...
Explain the difference between FLOAT, DOUBLE and REAL.
- 14 Answers
- 74702 Views
- Yahoo, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / boobalan
Float is data type which holds the 8 bytes memory to
holds the floating values even if we give the values in
integer(4)it takes as float(4.0).
Double is also same to the float that is also takes 8
bytes main purpose is to holds the long values of varible
(example:phone no),thank you.......
| Is This Answer Correct ? | 2 Yes | 12 No |
Answer / leena
Float is 8 bytes with 15 digits precision
Double is same as float
Real is 4 bytes with 7 digits precision
| Is This Answer Correct ? | 13 Yes | 63 No |
Answer / manager
float floats on water and double drowns in water
| Is This Answer Correct ? | 21 Yes | 118 No |
What is mysql default database?
What could be the reason that the mysql statement 'select avg (salary) from emp' generates an inaccurate output?
Does mysql need a server?
Is mysql good for large database?
How to see table's field formats or description of table .
How do I copy a table in mysql workbench?
Can mysql and mariadb coexist?
What are the benefits of mysql?
Can we rollback truncate in mysql?
How do I create a schema in mysql?
What is clob datatype?
How does mysql clustering work?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
