-- 按年龄升序排序 SELECT * FROM users ORDER BY age ASC; -- 按创建时间降序排序 SELECT * FROM users ORDER BY created_at DESC; -- 多字段排序 SELECT * FROM users ORDER BY city ASC, age DESC;
-- 按年龄升序排序 SELECT * FROM users ORDER BY age ASC; -- 按创建时间降序排序 SELECT * FROM users ORDER BY created_at DESC; -- 多字段排序 SELECT * FROM users ORDER BY city ASC, age DESC;