new一个对象1
new一个对象1
全部文章
分类
Mysql(1)
题解(25)
归档
标签
去牛客网
登录
/
注册
new一个对象1的博客
全部文章
(共17篇)
题解 | #牛客每个人最近的登录日期(二)#
select u.name as u_n,c.name as c_n ,date d from login l left join user u on l.user_id=u.id left join client c on l.client_id= c.id WHERE exi...
Mysql
2021-09-17
0
209
题解 | #异常的邮件概率#
select date,(round((count(type='no_completed' or null))/count(1),3)) p from (select date,type from email e where exists (select * from user u where e...
Mysql
2021-09-16
0
211
题解 | #对于employees表中,给出奇数行的first_name#
select first_name from employees where first_name in ( select first_name from ( select first_name,(@i:=@i+1) n from ( select...
Mysql
2021-09-16
0
196
题解 | #统计salary的累计和running_total#
select emp_no,salary,convert((@i:=@i+salary),signed) as running_total from salaries s , (select @i:=0 )t where to_date='9999-01-01'
Mysql
2021-09-16
0
220
题解 | #获取有奖金的员工相关信息。#
考虑到有的员工可能没有奖金 所以后面要用inner join select e.emp_no,first_name,last_name,btype,salary, salary*(0.1*(if(btype>2,3,btype))) as bonus from employees e le...
Mysql
2021-09-16
0
213
题解 | #查找排除当前最大、最小salary之后的员工的平均工资avg_salary#
select ((sum(salary)-min(salary)-max(salary))/(count(1)-2)) avg_salary from salaries where to_date='9999-01-01'
Mysql
2021-09-16
0
210
题解 | #查找描述信息中包含robot的电影对应的分类名称以及电影数目,而且还需要该分类对应电影数量>=5部#
真的是头疼,找不到工作。我哭了。。。(先计算每个电影类型对应的电影数量,然后再关联查询) select r2.name,count(1) from (select fc.category_id from film f left join film_category fc on f.film_i...
Mysql
2021-09-14
0
198
首页
上一页
1
2
下一页
末页