我能找到工作吗？

分类

题解(26)

/ 注册

全部文章（共5篇）

题解 | #修改表#

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

Mysql

2021-12-17

0 319

题解 | #修改表#

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

2021-12-17

0 302

题解 | #创建一张新表#

id int(11) not null primary Key auto_increment comment '自增ID', uid int(11) not null unique Key comment '用户ID', nick_name varchar(64) Comment '...

Mysql

2021-12-17

0 357

题解 | #统计作答次数#

select count(er.id) as total_pv, sum(case when er.submit_time is not null then 1 else 0 end) as complete_pv, count(distinct case when er...

Mysql

2021-10-21

0 356

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

SELECT ei.tag,ei.difficulty, ROUND((SUM(er.score)-max(er.score)-MIN(score))/(count(er.score)-2),1) clip_avg_score FROM examination_info ei join exam_...

Mysql

2021-10-21

0 359