SELECT greatest(DATE'2020-01-01',DATE'2020-01-03',DATE'2020-01-05',DATE'2020-01-07',DATE'2020-01-09') 最大值,
least(1,3,5,7,9) 最小值
FROM dual;
SELECT 1 FROM dual
WHERE greatest(1,3,5,7,9) > 8;
SELECT greatest(DATE'2020-01-01',DATE'2020-01-03',DATE'2020-01-05',DATE'2020-01-07',DATE'2020-01-09') 最大值,
least(1,3,5,7,9) 最小值
FROM dual;
SELECT 1 FROM dual
WHERE greatest(1,3,5,7,9) > 8;