周粥粥ph

分类

题解(21)

/ 注册

全部文章（共19篇）

题解 | #牛客每个人最近的登录日期(三)#

select round(count(m.date)/count(m.d),3) from (SELECT x.user_id, x.d, l2.date from (SELECT l.user_id, min(l.date) as d FROM login l GROUP BY l.us...

Mysql

2021-09-25

0 287

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

select x.u_n, x.c_n, x.date from (SELECT u.name as u_n, c.name as c_n, l.date, row_number()over(PARTITION by u.name order by l.date desc)mm FROM logi...

Mysql

2021-09-25

0 331

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

SELECT f.title,f.description FROM film f where f.film_id in (select fc.film_id from film_category fc where fc.category_id in (select category_id fr...

Mysql

2021-09-23

0 334

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

SELECT c.name, count(f.film_id) AS c FROM film f LEFT JOIN film_category fc on f.film_id = fc.film_id LEFT JOIN category c on fc.category_id = c.categ...

Mysql

2021-09-23

0 263

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

SELECT de.dept_no, d.dept_name, t.title, count(t.title) FROM dept_emp de LEFT JOIN departments d on de.dept_no = d.dept_no LEFT JOIN titles t on t.em...

Mysql

2021-09-23

0 299

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

select emp_no, salary, dense_rank()over(order by salary DESC) as"t_rank" FROM salaries order by t_rank ,emp_no

Mysql

2021-09-23

0 287

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

select x.dept_no, x.emp_no, x.salary as maxSalary FROM (SELECT de.dept_no, de.emp_no, s.salary, row_number()over(partition by de.dept_no order by s.s...

Mysql

2021-09-23

0 253

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

select x.dept_no, x.emp_no, x.salary as maxSalary FROM (SELECT de.dept_no, de.emp_no, s.salary, row_number()over(partition by de.dept_no order by s.s...

Mysql

2021-09-23

0 310

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

select x.dept_no, x.emp_no, x.salary as maxSalary FROM (SELECT de.dept_no, de.emp_no, s.salary, row_number()over(partition by de.dept_no order by s.s...

Mysql

2021-09-23

1 293