MENU
Comparison
| SELECT COALESCE(NULL, NULL, 3, 4, 5, NULL); -- first non-NULL argument |
3 |
| SELECT COALESCE(NULL, NULL, NULL); | NULL |
| SELECT GREATEST(1, 3.2, 2); | 3.2 |
| SELECT LEAST('x','y','z'); | x |
| SELECT INTERVAL(5,1,3,7,8,9); -- 2 smaller integers between 5 and 7 |
2 |
| SELECT INTERVAL(5,5,1,3); | 3 |