How can I represent 4-byte single-precision floating point numbers in Databricks SQL and what are their limits?
4-byte single-precision floating point numbers can be represented in Databricks SQL using the `FLOAT` or `REAL` syntax. The range of numbers that can be represented is from -3.402E+38 to +3.402E+38, including negative infinity, positive infinity, and NaN (not a number). Here are some examples of how to represent these numbers:

* `+1F` represents 1.0
* `5E10F` represents 5E10
* `5.3E10F` represents 5.3E10
* `-.1F` represents -0.1
* `2.F` represents 2.0
* `-5555555555555555.1F` represents -5.5555558E15
* `CAST(6.1 AS FLOAT)` represents 6.1

Note that `FLOAT` is a base-2 numeric type, so the representation of base-10 literals may not be exact. If you need to accurately represent fractional or large base-10 numbers, consider using the `DECIMAL` type instead.