SQL differences
GREATEST Skips NULL on PostgreSQL and Returns NULL on MySQL
GREATEST(sale_price, list_price) picks the larger of two prices. When one of them is NULL, PostgreSQL still picks the other price, and no other engine does. GREATEST(1, …
Tag
NULL and Sorting
SQL differences
NULL Sorts First on SQLite and MySQL and Last on PostgreSQL
Sort customers by the date of their last order and the ones who never ordered come first on SQLite, MySQL and MariaDB and last on PostgreSQL. The first page of the same …
SQL differences
NULLS FIRST and NULLS LAST Fail on MySQL and MariaDB
ORDER BY shipped_at NULLS LAST is the tidy way to put unshipped orders at the end on PostgreSQL and SQLite. MySQL and MariaDB have no such syntax and refuse the query. …