least

description

Syntax

least(col_a, col_b, …, col_n)

column支持以下类型：TINYINT SMALLINT INT BIGINT LARGEINT FLOAT DOUBLE STRING DATETIME DECIMAL

比较n个column的大小返回其中的最小值.若column中有NULL，则返回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