jxnu-18级-叶乐敏

题解

/ 注册

全部文章 / 题解（共7篇）

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

select gradefrom ( select *,( select sum(number) from class_grade where grade<=c.grade ) t_rank from class_grade c ...

2021-08-02

0 344

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

select t.*from ( select ,( select count(distinct score) from grade where g.job=job and g.score<=score ) t_rank from g...

2021-08-01

0 398

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

select g.id,l.name,g.scorefrom grade ginner join language lon g.language_id=l.idwhere g.score in ( select score from ( select distinct sc...

2021-08-01

0 294

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

select distinct l.date,IFNULL(new,0)from login lleft join ( select min_date,count(*) new from ( select min(date) min_date from log...

2021-08-01

0 249

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

select round((select count(distinct l1.user_id)from login l1inner join login l2on datediff(l2.date,l1.date)=1 and l1.user_id=l2.user_idinner join( ...

2021-08-01

0 309

题解 | #对于employees表中，给出奇数行的first_name#

select first_namefrom ( select first_name,( select count(*) from employees where e.first_name>=first_name ) rank from...

2021-08-01

0 311

题解 | #查找字符串 10,A,B 中逗号,出现的次数cnt#

select avg(salary) avg_salaryfrom salarieswhere to_date='9999-01-01' and salary not in( (select min(salary) from salaries where to_date='9999...

2021-08-01

0 274