order byでのnullの扱い、各DBで異なるなとは思っていたけど、DuckDBだけascでもdescでも常に最後になるのか。（nulls firstはできる）
PostgreSQLがorder by 句に式を使えないのも意外
Modern SQL@ModernSQL
ORDER BY Has Come a Long Way modern-sql.com/blog/2026-05/o… The ORDER BY clause is one of the best-known SQL clauses. Yet there are a number of common misunderstandings that are worth clearing up. The article walks you through the evolution of the ORDER BY clause in the SQL standard.
日本語
