ORDER BY排序
课程:SQL · 编程练习
SQL编程练习 - ORDER BY排序
练习内容
-- 按年龄升序排序\nSELECT * FROM users ORDER BY age ASC;\n\n-- 按创建时间降序排序\nSELECT * FROM users ORDER BY created_at DESC;\n\n-- 多字段排序\nSELECT * FROM users\nORDER BY city ASC, age DESC;\n\n
课程:SQL · 编程练习
SQL编程练习 - ORDER BY排序
-- 按年龄升序排序\nSELECT * FROM users ORDER BY age ASC;\n\n-- 按创建时间降序排序\nSELECT * FROM users ORDER BY created_at DESC;\n\n-- 多字段排序\nSELECT * FROM users\nORDER BY city ASC, age DESC;\n\n