least

description

Syntax

least(col_a, col_b, …, col_n)

column supports the following types: TINYINT SMALLINT INT BIGINT LARGEINT FLOAT DOUBLE STRING DATETIME DECIMAL

Compare the size of n columns and return the smallest among them. If there is NULL in column, return NULL.

example

1. mysql> select least(-1, 0, 5, 8);
2. +--------------------+
3. | least(-1, 0, 5, 8) |
4. +--------------------+
5. |                 -1 |
6. +--------------------+
7. mysql> select least(-1, 0, 5, NULL);
8. +-----------------------+
9. | least(-1, 0, 5, NULL) |
10. +-----------------------+
11. | NULL                  |
12. +-----------------------+
13. mysql> select least(6.3, 4.29, 7.6876);
14. +--------------------------+
15. | least(6.3, 4.29, 7.6876) |
16. +--------------------------+
17. |                     4.29 |
18. +--------------------------+
19. mysql> select least("2022-02-26 20:02:11","2020-01-23 20:02:11","2020-06-22 20:02:11");
20. +----------------------------------------------------------------------------+
21. | least('2022-02-26 20:02:11', '2020-01-23 20:02:11', '2020-06-22 20:02:11') |
22. +----------------------------------------------------------------------------+
23. | 2020-01-23 20:02:11                                                        |
24. +----------------------------------------------------------------------------+

keywords

1. LEAST