jaime_

题解

/ 注册

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

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

SELECT l.date, COUNT(CASE WHEN l.user_id=a.user_id AND l.date=a.date THEN l.user_id ELSE null END) new FROM login l, ( SELECT user_id,MIN(dat...

Mysql

2021-11-30

0 320

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

SELECT ROUND(COUNT(DISTINCT user_id)/(SELECT COUNT(DISTINCT user_id) FROM login),3) FROM login WHERE (user_id,date) IN ( SELECT user_id,DATE_ADD(...

Mysql

2021-11-30

0 376

题解 | #统计salary的累计和running_total#

SELECT emp_no, salary, sum(salary)over(rows between unbounded preceding and current row) running_total FROM salaries WHERE to_date='9999-01-01'; ...

Mysql

2021-11-29

0 281