MySQL ORDER BY with nulls first or last (at bottom or top)
September 29, 2024
#database #mysql #reading-list
🔗 MySQL ORDER BY with nulls first or last (at bottom or top)
gregrs-uk.github.io
Want to create a MySQL query where a column is sorted in ascending order but with nulls last (at the bottom), or where a column is sorted in descending order but with nulls first (at the top)? You can use
ISNULL(column)to do this.
continue reading on gregrs-uk.github.io
⚠️ This post links to an external website. ⚠️
If this post was enjoyable or useful for you, please share it! If you have comments, questions, or feedback, you can email my personal email. To get new posts, subscribe use the RSS feed.