Jarlin
Jarlin
全部文章
分类
题解(21)
归档
标签
去牛客网
登录
/
注册
Jarlin的博客
全部文章
(共8篇)
题解 | #实习广场投递简历分析(二)#
select job, DATE_FORMAT(date,'%Y-%m') as mon, sum(num) as cntfrom resume_infowhere date like "2025%"group by job,monorder by mon desc,cnt de...
2021-07-04
0
450
题解 | #牛客的课程订单分析(六)#
select c.id,c.is_group_buy,client.namefrom( //子查询,找出符合要求的订单 select * from order_info a where a.user_id in ( //子查询,找出VIP客户 select b.user_id ...
2021-07-04
0
353
题解 | #牛客的课程订单分析(二)#
select user_idfrom order_infowhere date>'2025-10-15' and status='completed' and product_name in ('C++','Python','Java')group by user_idhaving count...
2021-07-04
0
294
题解 | #考试分数(二)#
select a.id, a.job, a.scorefrom grade aleft join( select b.job,avg(b.score) as job_avg from grade b group by b.job) as con a.job = c.jobwhere...
2021-07-04
0
351
题解 | #刷题通过的题目排名#
select a.id,a.number,( select count(distinct(number)) //数量上大于等于当前,且去重后计数 from passing_number b where b.number>=a.number)as t_rank //另外添加...
2021-07-04
0
363
题解 | #构造一个触发器audit_log#
create trigger audit //触发器名字after insert on employees_test //触发条件for each row //触发条件(行级触发器)begin insert into audit //触发内容 values(new....
2021-06-27
0
433
题解 | #批量插入数据,不使用replace操作#
create table actor_name( first_name varchar(45) not null, last_name varchar(45) not null);insert into actor_nameselect first_name,last_namefrom ac...
2021-06-26
0
480
题解 | #批量插入数据,不使用replace操作#
insert into actorselect '3','ED','CHASE','2006-02-15 12:34:33'from actorwhere not exists( select * from actor where actor_id='3');
2021-06-26
0
385