great、DY

分类

题解(13)

/ 注册

全部文章（共13篇）

题解 | #考试分数(三)#

select t1.id,l.name,t1.score from( select id,language_id,score, dense_rank() over(partition by language_id order by score desc) score_rank > fr...

Mysql

2021-10-10

1 493

题解 | #异常的邮件概率#

select date,round(sum(if(type='no_completed',1,0))/count(id),3) p from email where send_id not in (select id&n...

Mysql

2021-10-10

0 277

题解 | #获取所有非manager员工当前的薪水情况#

select dept_no,e.emp_no as e_emp_no,salary from employees e, dept_emp de,salaries s where e.emp_no=de.emp_no and s.emp_no=e.emp_no and e.emp_no not in...

Mysql

2021-10-09

0 290