
Answer-first summary for fast verification
Answer: DOUBLE, REAL
According to Snowflake documentation and the unanimous community consensus (100% agreement with upvoted comments), DOUBLE and REAL are synonymous with FLOAT. The Snowflake documentation explicitly states that DOUBLE, DOUBLE PRECISION, and REAL are all synonymous with FLOAT, representing floating-point numbers with double precision. DECIMAL and NUMERIC are fixed-point numeric types, not synonymous with FLOAT. NUMBER is a general numeric type that can represent both fixed-point and floating-point numbers, but it is not specifically synonymous with FLOAT.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.