熊猫不如猫熊

分类

/ 注册

全部文章（共77篇）

题解 | #截取出年龄#

select age ,count(*) from ( select device_id ,substring_index(substring_index(profile,',',3),',',-1) as age from user_sub...

2024-09-02

0 131

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

select e.emp_no,m.emp_no,e.emp_salary,m.manager_salary from ( select de.emp_no,de.dept_no,s.salary as emp_salary from dept_emp de left joi...

2024-09-02

0 98

题解 | #出现三次以上相同积分的情况#

select number from ( select number,count(*) as cnt from grade group by number ) as a where cnt>=3

2024-09-02

0 115

题解 | #出现三次以上相同积分的情况#

select number from ( select number,count(*) n from grade group by 1 ) a where n>=3

2024-09-01

0 117

题解 | #出现三次以上相同积分的情况#

select number from ( select number,count(*) n from grade group by 1 ) a where n>=3

2024-09-01

0 128

题解 | #刷题通过的题目排名#

select id ,number ,dense_rank() over (order by number desc) t_rank from passing_number

2024-09-01

0 111

题解 | #最差是第几名(一)#

select grade ,sum(number) over (order by grade asc) as t_tank from class_grade order by grade

2024-09-01

0 97

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

select u.name as u_n ,p.date ,sum(p.number) over (partition by u.name order by date) as ps_num from passing_number p left join us...

2024-09-01

0 93

题解 | #统计salary的和running_total

select emp_no ,salary ,sum(salary) over (order by emp_no asc) as running_total from salaries where to_date = '9999-01-01'

2024-09-01

0 98

题解 | #浙大不同难度题目的正确率#

select qd.difficult_level ,sum(if(qpd.result='right',1,0))/sum(if(qpd.result is not null,1,0)) from question_practice_detail qpd left jo...

2024-09-01

0 97