《MySQL入门学习》(p24~p26)

最新推荐文章于 2024-07-18 21:19:04 发布

garrulousabyss

最新推荐文章于 2024-07-18 21:19:04 发布

阅读量102

点赞数

分类专栏：数据库

本文链接：https://blog.csdn.net/garrulousabyss/article/details/100165374

版权

数据库专栏收录该内容

43 篇文章 0 订阅

订阅专栏

p24 今日内容

p25 DQL_排序查询

-- 排序查询
SELECT * FROM student ORDER BY math ASC; -- 默认是升序
SELECT * FROM student ORDER BY math DESC;

SELECT * FROM student ORDER BY math DESC,english ASC;

p26 DQL_聚合函数

-- 聚合函数
SELECT COUNT(english) FROM student;
SELECT COUNT(IFNULL(english,0)) FROM student;

SELECT COUNT(id) FROM student;

SELECT MAX(math) FROM student;

SELECT MIN(math) FROM student;

SELECT SUM(english) FROM student;

SELECT AVG(math) FROM student;