Collections
Datasets
Tools
CSV to SQL
JSON to SQL
My Books
Change password
Log out
Sign In
Use desktop for interactive SQL sandbox
Settings
Fork this book
Notes
SQL
MySQL - 8.0
Oracle - 21.3.0
PostgreSQL - 17
ERD
Run Code
Read-only book
Fork to Edit
Tip: Press
Alt
+
Enter
to run SQL
SQL Output
Clear
The Natural Sort Problem
Public
Humans expect 1, 2, 10. Databases give you 1, 10, 2. Learn the pattern for sorting embedded numbers correctly.
jrz1977
PostgreSQL
Created Feb 3, 2026
Contents
1
Notes
Notes
2
SQL
SQL
1 SQL
1 Notes
Switch to a SQL tab and press
Alt
+
Enter
to run queries
The Natural Sort Problem
Updated 2/3/26, 1:13 AM
Notes
SQL
Alt+Enter to run