排序与分组

编程代码 · SQL 数据库

💡 SQL 排序和分组：ORDER BY 排序，GROUP BY 分组统计

SELECT * FROM users ORDER BY age DESC;↵// ORDER BY age DESC 按年龄降序排列

SELECT city, COUNT(*) as total FROM users GROUP BY city;↵// GROUP BY city 按城市分组，COUNT 统计每组数量

SELECT department, AVG(salary) FROM employees GROUP BY department;↵// 按部门分组，AVG 计算每组平均工资

SELECT * FROM products ORDER BY price ASC LIMIT 10;↵// ASC 升序排列，LIMIT 10 只取前 10 条

SELECT status, COUNT(*) FROM orders GROUP BY status HAVING COUNT(*) > 5;// HAVING 对分组结果再筛选（COUNT > 5）

0 字/分0% 准确

🐵

S左手无名指

ESC 暂停⌫ 退格