SQL常用查询速查

SQL 常用查询速查表

基础查询

SELECT col1,col2 FROM table WHERE condition ORDER BY col LIMIT n;

聚合

COUNT(*)/SUM(col)/AVG(col)/MAX(col)/MIN(col)\nGROUP BY col HAVING condition

JOIN

INNER JOIN/LEFT JOIN/RIGHT JOIN table ON cond

子查询

SELECT * FROM t1 WHERE col IN (SELECT col FROM t2)

INSERT

INSERT INTO table (col1,col2) VALUES (v1,v2);

UPDATE

UPDATE table SET col=val WHERE cond;

DELETE

DELETE FROM table WHERE cond;

索引

CREATE INDEX idx_name ON table(col);

窗口函数

ROW_NUMBER()/RANK()/LAG(col)/LEAD(col) OVER (PARTITION BY col ORDER BY col)