牛客849999528号

分类

题解(11)

/ 注册

全部文章（共10篇）

题解 | #每篇文章同一时刻最大在看人数# 不是用的+-1的编码，用笛卡尔积做

select qqq.ti,max(qqq.nn) max_uv from (select tu1.artical_id as ti,tu1.uid tui, count(*)+1 nn from tb_user_log tu1 join tb_user_log tu2 on tu1.artical...

Mysql

2022-03-15

6 415

题解 | #满足条件的用户的试卷完成数和题目练习数#

with users as(SELECT er.uid from exam_record er join examination_info ei on er.exam_id=ei.exam_id join user_info ui on er.uid=ui.uid WHERE ei.tag='SQ...

Mysql

2021-11-09

0 319

题解 | #获取员工其当前的薪水比其manager当前薪水还高的相关信息#

select des.emp_no,dms.emp_no as manager_no,des.salary as emp_salary,dms.salary as manager_salary from (select de.emp_no,de.dept_no,sa.salary from dept...

Mysql

2021-10-24

0 237

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

SELECT de.dept_no, em.emp_no,sa.salary from employees em right join dept_emp de on em.emp_no =de.emp_no right join salaries sa on em.emp_no=sa.emp...

Mysql

2021-10-24

1 298

题解 | #查找在职员工自入职以来的薪水涨幅情况#

SELECT q1.emp_no,(q2.salary-q1.salary) as growth from (select sa.emp_no,sa.salary,sa.to_date from (select emp_no,min(to_date) as m_d from salaries ...

Mysql

2021-10-22

1 230

题解 | #获取当前薪水第二多的员工的emp_no以及其对应的薪水salary#

-- select max(sa.salaries) from employees em join salaries sa on em.emp_no=sa.emp_no select em.emp_no,mt.salary,em.last_name,em.first_name from employ...

Mysql

2021-10-22

1 260

题解 | #获取每个部门中当前员工薪水最高的相关信息#

SELECT de.dept_no,de.emp_no,qpd.maxSalary from dept_emp de left join salaries sa on de.emp_no =sa.emp_no right join (SELECT de.dept_no,max(sa.salary...

Mysql

2021-10-22

1 236

题解 | #查找薪水记录超过15次的员工号emp_no以及其对应的记录次数t#

SELECT sa.emp_no,sa.t from (SELECT emp_no,count(*) as t from salaries GROUP by emp_no )&nb...

Mysql

2021-10-22

1 276

题解 | #查找当前薪水详情以及部门编号dept_no#

SELECT dm.emp_no,salary,from_date,dm.to_date as to_date,dept_no from dept_manager as dm left join salaries as sa on dm.emp_no = sa.emp_no order by sa....

Mysql

2021-10-22

1 204

题解 | #统计复旦用户8月练题情况#

SELECT u.device_id ,u.university,case when all_q is null then 0 else all_q end as question_cnt , case when (r_q is null) then 0 else r_q end as right_...

Mysql

2021-10-21

1 239