OkMaid

题解

/ 注册

全部文章 / 题解（共33篇）

题解 | #每类试卷得分前3名#

SELECT tag,uid,ranking FROM ( SELECT b.tag,a.uid, ROW_NUMBER()OVER(PARTITION BY tag ORDER BY max(a.score) DESC,min(a.score) DESC,a.uid DESC) r...

Mysql

2022-06-29

0 301

题解 | #每个6/7级用户活跃情况#

跟着评论区一位大佬思路码的，太感谢大佬，思路豁然开朗 select u_i.uid as uid, count(distinct act_month) as act_month_total, count(distinct case when ...

Mysql

2022-06-29

0 334

题解 | #SQL类别高难度试卷得分的截断平均值#

select tag, difficulty, round(avg(score), 1)as clip_avg_score from exam_record t1 join examination_info t2 using(exam_id) where tag ='SQL' and difficu...

Mysql

2022-06-23

0 280

题解 | #删除索引#

alter table examination_info drop index uniq_idx_exam_id; alter table examination_info drop index full_idx_tag

Mysql

2022-06-12

0 260

题解 | #创建索引#

create index idx_duration on examination_info(duration); create unique index uniq_idx_exam_id on examination_info(exam_id); create fulltext index ful...

Mysql

2022-06-11

0 262

题解 | #修改表#

alter table user_info add column school varchar(15) after level; alter table user_info change job profession varchar(10); alter table user_info modify...

Mysql

2022-06-08

0 285

题解 | #创建一张新表#

create table user_info_vip( id int(11) not null primary key auto_increment comment '自增ID', uid int(11) not null unique key comment '用户ID', nick_name v...

Mysql

2022-06-08

0 244

题解 | #删除记录（三）#

DELETE FROM nowcoder_exam_record; ALTER TABLE nowcoder_exam_record auto_increment=1; truncate nowcoder_exam_record;

Mysql

2022-06-06

0 356

题解 | #删除记录（二）#

delete from exam_record where score is null or timestampdiff(minute, start_time, ...

Mysql

2022-06-04

0 318

题解 | #删除记录（一）#

delete from exam_record where score < 60 and timestampdiff(minute, start_time, ...

Mysql

2022-06-04

0 263