please tell me the use of DOUBLE data type?

Answer 1

It's for storing decimal numbers, with a higher precision than FLOAT.

Answer 2

DOUBLE PRECISION

The REAL data type accepts approximate numeric values, up to a precision of 64. No parameters are required when declaring a DOUBLE PRECISION data type. If you attempt to assign a value with a precision greater than 64 an error is raised.