greatest

description

Syntax

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

keywords

  1. GREATEST