ORDER BY Result
Predict Output Beginner
Question
What does this SQL produce?
Code
-- users: names "Charlie", "Alice", "Bob"
SELECT name FROM users ORDER BY name ASC;
Hint
ORDER BY sorts alphabetically ascending.
Explanation
ORDER BY name ASC sorts the names in ascending alphabetical order: Alice, Bob, Charlie. ASC is the default sort direction.
Related Resources
Related Lessons
- SELECT
Learn SELECT.
Look up unfamiliar terms
A beginner-friendly glossary explains jargon in plain English — variables, functions, DOM, Promise, and more.
Decode error messages
Plain-English explanations of common errors — what they mean, why they happen, and how to fix them.
Build real projects
Apply what you learned by building guided projects with starter code and solutions.