🔍 基础查询
SELECT语句示例
SELECT * FROM users WHERE active = 1;
🔗 多表关联
JOIN查询示例
SELECT u.name, p.title FROM users u LEFT JOIN posts p...
🎯 子查询
嵌套查询示例
SELECT * FROM users WHERE id IN (SELECT user_id...
📊 聚合函数
GROUP BY和聚合函数
SELECT category, COUNT(*), AVG(price) FROM products...
🌳 CTE查询
WITH子句示例
WITH RECURSIVE category_tree AS (SELECT...)...
🪟 窗口函数
OVER子句示例
SELECT name, salary, ROW_NUMBER() OVER...
➕ 插入数据
INSERT语句示例
INSERT INTO users (name, email) VALUES...
🏗️ 创建表
DDL语句示例
CREATE TABLE users (id INT PRIMARY KEY...)...