少糖去冰啊_

分类

/ 注册

全部文章（共67篇）

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

WITH t1 as (SELECT l.user_id as id, p.date as d1, sum(sum(number)) over (partition by l.user_id order by p.date ROWS between UNBOUNDED PRECEDING and C...

2025-10-25

0 13

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

WITH t1 as( SELECT U.name as u_n, C.name as c_n, l.date as date, rank()over(partition by U.name Order by l.date desc) as rnk FROM login l LEFT JOIN u...

2025-10-25

0 20

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

WITH t1 as( SELECT U.name as u_n, C.name as c_n, l.date as date, rank()over(partition by U.name Order by l.date desc) as rnk FROM login l LEFT JOIN u...

2025-10-25

0 8

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

SELECT user_id, max(date) as date FROM login GROUP BY user_id ORDER BY user_id

2025-10-25

0 19

题解 | 按照dept_no进行汇总

SELECT dept_no, group_concat(emp_no) as employees FROM dept_emp GROUP BY dept_no

2025-10-25

0 16

题解 | 获取employees中的first_name

SELECT first_name FROM employees ORDER BY right(first_name,2)

2025-10-25

0 14

题解 | 使用子查询的方式找出属于Action分类的所有电影对应的title,description

SELECT f.title, f.description FROM film f LEFT JOIN film_category fc on f.film_id=fc.film_id LEFT JOIN category c on fc.category_id = c.category_id WH...

2025-10-19

0 20

题解 | 使用join查询方式找出没有分类的电影id以及名称

SELECT f.film_id, f.title FROM film f LEFT JOIN film_category fc on f.film_id=fc.film_id LEFT JOIN category c on fc.category_id = c.category_id WHERE ...

2025-10-19

0 16

题解 | 汇总各个部门当前员工的title类型的分配数目

SELECT d2.dept_no, dept_name,t.title, count(*) as count FROM dept_emp d LEFT JOIN titles t on d.emp_no = t.emp_no LEFT JOIN departments d2 on d.dept_n...

2025-10-19

0 18

题解 | 对所有员工的薪水按照salary降序进行1-N的排名

SELECT emp_no, salary, dense_rank()over(order by salary desc) as t_rank FROM salaries

2025-10-19

0 15