Which data type can be used for floating-point numbers without losing precision?
Which data type can be used for floating-point numbers without losing precision?
The correct data type for floating-point numbers without losing precision is DOUBLE. BINARY is used for binary data, VARIANT can store semi-structured data but does not guarantee precision for floating-point numbers, and INTEGER is for whole numbers.
https://docs.snowflake.com/en/sql-reference/data-types-numeric