![](https://img-blog.csdnimg.cn/20201014180756927.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
mysql
mysql相关
江湖峰哥
这个作者很懒,什么都没留下…
展开
-
Mysql窗口函数之组内SUM、AVG操作
-- 测试数据参考 https://www.cnblogs.com/thxj/p/12727589.htmlSELECT `name`, `course`, `score`, SUM( score ) over ( PARTITION BY `course` ) AS course_score_total , ROUND(AVG(score) over (...原创 2020-05-03 13:48:10 · 1158 阅读 · 0 评论 -
Mysql窗口函数之组内逐行连续SUM、AVG操作
/*测试数据 参考 https://www.cnblogs.com/thxj/p/12727589.html*/CREATE TABLE `school_score` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` char(1) DEFAULT NULL, `course` char(10) DEFAULT NULL, `sco...原创 2020-05-03 13:36:01 · 775 阅读 · 0 评论 -
windows安装mysql 8.x
https://blog.csdn.net/qq_37350706/article/details/81707862转载 2020-04-30 01:12:40 · 83 阅读 · 0 评论