![](https://img-blog.csdnimg.cn/20201014180756919.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
sql
梦雨心思
这个作者很懒,什么都没留下…
展开
-
学生成绩排行-sql
学生成绩排行 建立表语句 CREATE TABLE `student` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(20) DEFAULT NULL, `score` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8; 查询全部 select * from stud原创 2021-03-19 14:33:57 · 986 阅读 · 0 评论 -
mysql 统计连续为正数出现的次数
select * from static_log; select name,count(count_nu) from (select `name`,count_nu, case when count_nu >0 then (@c := @c + 1) end as zz, case when count_nu < 0 then (@b + @c) end as cc from st...原创 2019-09-20 21:30:03 · 518 阅读 · 0 评论