user_id | name | city | age |
---|---|---|---|
1 | John Doe | New York | 15 |
2 | Jimmy McNulty | Los Angeles | 44 |
2 | Andrew Wilkins | Chicago | 15 |
2 | Bob Seizmore | New York | 16 |
SELECT * FROM users ORDER BY name;
Result:
user_id | name | city | age |
---|---|---|---|
2 | Andrew Wilkins | Chicago | 15 |
2 | Bob Seizmore | New York | 16 |
2 | Jimmy McNulty | Los Angeles | 44 |
1 | John Doe | New York | 15 |