92. Alphabetical Sorting

Alphabetical Order

Sort text columns alphabetically.

1SELECT name FROM students
2ORDER BY name;

Returns A-Z order: Alice, Bob, Carol...

With Other Columns

1SELECT name, course FROM students
2ORDER BY course, name;