> 激活词: 数据?/ SQL / database / 查询
-- 基础查询
SELECT * FROM users WHERE age > 30 ORDER BY name LIMIT 10;
-- 聚合
SELECT city, COUNT(*) as cnt, AVG(age) as avg_age
FROM users GROUP BY city HAVING cnt > 1;
-- 联表
SELECT u.name, o.amount
FROM users u
JOIN orders o ON u.id = o.user_id
WHERE o.status = 'completed';
-- 窗口函数
SELECT name, age,
RANK() OVER (ORDER BY age DESC) as rank
FROM users;
共 2 个版本