牛客567868013号

分类

SQL题解(12) 题解(18)

/ 注册

全部文章（共30篇）

题解 | #两个链表的第一个公共结点#

# class ListNode: # def __init__(self, x): # self.val = x # self.next = None # # # @param pHead1 ListNode类 # @param pHead2 List...

Python3 剑指

2021-10-13

0 313

题解 | #二叉搜索树与双向链表#

# class TreeNode: # def __init__(self, x): # self.val = x # self.left = None # self.right = None # # # @param pRootOfTre...

Python3 剑指

2021-10-13

0 420

题解 | #复杂链表的复制#

# -*- coding:utf-8 -*- # class RandomListNode: # def __init__(self, x): # self.label = x # self.next = None # self.random ...

Python3 剑指

2021-10-13

1 384

题解 | #合并两个排序的链表#

# -*- coding:utf-8 -*- # class ListNode: # def __init__(self, x): # self.val = x # self.next = None class Solution: # 返回合并后列表 ...

Python3 剑指

2021-10-12

0 411

题解 | #链表中倒数最后k个结点#

# class ListNode: # def __init__(self, x): # self.val = x # self.next = None # # 代码中的类名、方法名、参数名已经指定，请勿修改，直接返回方法规定的值即可 # # # @para...

Python3 剑指

2021-10-12

0 380

题解 | #从尾到头打印链表#

# -*- coding:utf-8 -*- # class ListNode: # def __init__(self, x): # self.val = x # self.next = None # # 代码中的类名、方法名、参数名已经指定，请勿修改，直接...

Python3 剑指

2021-10-12

1 297

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

select user.name,b.date,b.ps_num from (select pn.user_id,pn.date,sum(pn2.number) as ps_num from passing_number pn inner join passing_number pn2 on pn...

Sqlite

2021-09-29

0 273

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

select login.date, case when b.user_id is NULL then 0 else b.new_id end as new #将没有新用户（null）的日期对应的new值赋0 from login left join (select *,count(user_id)...

Sqlite

2021-09-29

0 299

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

select round(count(login.user_id)*1.0/count(b.user_id),3) as p from (select *, date(a.date,'+1 day') as next from (select * ,rank() over (PARTITION by...

Sqlite

2021-09-29

0 338

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

#窗口函数的使用 select user.name,client.name,a.date from (select *, rank() OVER(PARTITION by user_id ORDER by date DESC) as number from login) as a left joi...

Sqlite

2021-09-29

0 320