In most common database systems, including SQL Server, MySQL, Oracle, PostgreSQL, etc., Scientific notation is supported to represent numbers. You can use a power of 5 similar to 1e5 to represent 10, which is 100000.
You can also use 1e+ 5 to represent 100000
But if+ If there are spaces before and after, it will affect the final result. Pay attention to the influence of spaces.
SELECT
1e + 5
, 1e+5
, 1e5
