+------------------------------+
1 row in set
示例3:参数值为字符串,不区分大小写。
gbase> SELECT GREATEST('B','a','C') FROM dual;
+-----------------------+
| GREATEST('B','a','C') |
+-----------------------+
| C
|
+-----------------------+
1 row in set
示例4:参数值为字符串,字符串参数前加上BINARY,区分大小写。
gbase> SELECT GREATEST('B',BINARY 'a','C') FROM dual;
+------------------------------+
| GREATEST('B',BINARY 'a','C') |
+------------------------------+
GBase 8a MPP Cluster 产品手册
5 数据库管理指南
文档版本953(2022-04-10)
南大通用数据技术股份有限公司
655
| a
|
+------------------------------+
1 row in set
示例5:参数值中包含NULL,则执行结果为NULL。
gbase> SELECT GREATEST('B',NULL,'C') FROM dual;
+------------------------+
| GREATEST('B',NULL,'C') |
+------------------------+
| NULL
|
+------------------------+
1 row in set