爱呆呆范文网,文案写作帮手
爱呆呆范文网其他 经典常用SQL语句大全

经典常用SQL语句大全(常用sql语句大全)

时间:2023-12-17 00:00 下载全文

1. 创建表:CREATE TABLE table_name (column_name1 data_type1, column_name2 data_type2, …);

2. 插入数据:INSERT INTO table_name (column_name1, column_name2, …) VALUES (value1, value2, …);

3. 更新数据:UPDATE table_name SET column_name = new_value WHERE condition;

4. 删除数据:DELETE FROM table_name WHERE condition;

5. 查询数据:SELECT column_name FROM table_name WHERE condition;

6. 查找最大值:SELECT MAX(column_name) FROM table_name;

7. 查找最小值:SELECT MIN(column_name) FROM table_name;

8. 计算平均值:SELECT AVG(column_name) FROM table_name;

9. 计算总和:SELECT SUM(column_name) FROM table_name;

10. 统计行数:SELECT COUNT(*) FROM table_name;

11. 按列排序:SELECT column_name FROM table_name ORDER BY column_name ASC/DESC;

12. 按多列排序:SELECT column_name1, column_name2 FROM table_name ORDER BY column_name1 ASC, column_name2 DESC;

13. 分组统计:SELECT column_name, COUNT(*) FROM table_name GROUP BY column_name;

14. 连接表:SELECT , FROM table1 INNER JOIN table2 ON = ;

15. 聚合函数:SELECT COUNT(column_name), SUM(column_name), AVG(column_name), MAX(column_name), MIN(column_name) FROM table_name;

16. 子查询:SELECT column_name FROM table_name WHERE column_name IN (SELECT column_name FROM table_name2 WHERE condition);

17. 使用别名:SELECT column_name AS alias_name FROM table_name;

18. 使用通配符:SELECT * FROM table_name WHERE condition;

19. 模糊查询:SELECT column_name FROM table_name WHERE column_name LIKE '%keyword%';

经典常用SQL语句大全.doc

将文本的Word文档下载到电脑,方便打印,也可以【点击这里收藏】

推荐度: