swaaaay

题解

未归档(36)

/ 注册

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

题解 | #跳台阶# 来自专栏

# -*- coding:utf-8 -*- class Solution: def jumpFloor(self, number): # write code here ans=[0,1,2] for i in range(3,number+...

Python3

2021-11-29

0 340

题解 | #考试分数(二)# 来自专栏

SELECT g1.id,g1.job,g1.score FROM grade g1 WHERE g1.score>(select avg(score) from grade g2 where g1.job=g2.job) ORDER BY g1.id

Mysql

2021-11-24

0 342

题解 | #考试分数(一)# 来自专栏

SELECT job, round(avg(score),3) avg FROM grade GROUP BY job ORDER BY avg(score) DESC

Mysql

2021-11-24

0 352

题解 | #创建一个actor_name表# 来自专栏

create table actor_name (select first_name,last_name from actor)

Mysql

2021-11-24

1 360

题解 | #批量插入数据# 来自专栏

insert into actor values (1,'PENELOPE','GUINESS','2006-02-15 12:34:33'),(2,'NICK','WAHLBERG','2006-02-15 12:34:33')

Sqlite

2021-11-24

0 297

题解 | #找出单向链表中的一个节点，该节点到尾指针的距离为K# 来自专栏

列表转链表，再双指针 class node: def __init__(self, data): self.val = data self.next = None class Solution: def __init__(self):...

Python3 链表

2021-11-23

0 534

题解 | #删除链表中重复的结点# 来自专栏

字典计数，数组转链表的解法 class Solution: def deleteDuplication(self , pHead: ListNode) -> ListNode: # write code here if not pHead: retur...

Python3 数组链表

2021-11-23

0 380

题解 | #字符串分隔# 来自专栏

def get_ans(s): if not s: return None if len(s)==8: return s elif 0<len(s)<8: return add_zero(s) else: li=[] tup...

Python3 字符串数组

2021-11-18

0 430

题解 | #字符串排序# 来自专栏

def get_ans(que_li): que_li=sorted(que_li) return que_li if __name__=='__main__': import sys lines = [] while True: line ...

Python3 数组字符串

2021-11-18

0 389

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

select u.name u_n, c.name c_n, max(date) from login l inner join user u on l.user_id=u.id left join client c on l.client_id=c.id group by l.user_id ...

Sqlite

2021-11-17

0 317