安装命令
npx skills add https://github.com/0xdarkmatter/claude-mods --skill sql-ops🇨🇳中文介绍
SQL 模式
常用 SQL 模式的快速参考。
CTE（公共表表达式）
WITH active_users AS (
SELECT id, name, email
FROM users
WHERE status = 'active'
)
SELECT * FROM active_users WHERE created_at > '2024-01-01';
链式 CTE
WITH
active_users AS (
SELECT id, name FROM users WHERE status = 'active'
),
user_orders AS (
SELECT user_id, COUNT(*) as order_count
FROM orders GROUP BY user_id
)
SELECT u.name, COALESCE(o.order_count, 0) as orders
FROM active_users u
LEFT JOIN user_orders o ON u.id = o.user_id;
窗口函数（快速参考）
| 函数 | 用途 |
|---|---|
ROW_NUMBER() | 唯一顺序编号 |
RANK() | 带间隔的排名（1, 2, 2, 4） |
🇺🇸English
SQL Patterns
Quick reference for common SQL patterns.
CTE (Common Table Expressions)
WITH active_users AS (
SELECT id, name, email
FROM users
WHERE status = 'active'
)
SELECT * FROM active_users WHERE created_at > '2024-01-01';
Chained CTEs
WITH
active_users AS (
SELECT id, name FROM users WHERE status = 'active'
),
user_orders AS (
SELECT user_id, COUNT(*) as order_count
FROM orders GROUP BY user_id
)
SELECT u.name, COALESCE(o.order_count, 0) as orders
FROM active_users u
LEFT JOIN user_orders o ON u.id = o.user_id;
Window Functions (Quick Reference)
| Function | Use |
|---|---|
ROW_NUMBER() | Unique sequential numbering |
RANK() |
广告位招租
在这里展示您的产品或服务
触达数万 AI 开发者，精准高效
