jia2023
jia2023
全部文章
分类
题解(2)
归档
标签
去牛客网
登录
/
注册
jia2023的博客
全部文章
(共5篇)
题解 | #获取每个部门中当前员工薪水最高的相关信息#
select t1.dept_no,t2.emp_no,t1.maxSalary from (select d.dept_no, any_value(d.emp_no), max(s.salary) as maxSalary from dept_emp d inner join salaries a...
2023-05-30
0
134
题解 | #有序的列表#
my_list = ['P','y','t','h','o','n'] list2 = sorted(my_list) print(list2) print(my_list) my_list.sort(reverse=True) print(my_list) ...
数组
Python3
2022-08-05
8
275
题解 | #牛牛的年龄#
from datetime import datetime one = input() two = input() birthday = datetime.strptime(one,'%Y%m%d %...
字符串
Python3
2022-07-26
0
176
题解 | #牛牛的矩阵乘法#
import copy x = [[13,-1,4], [5,0,6], [1,9,-3]] y = copy.deepcopy(x) z =&...
Python3
数组
2022-07-20
0
217
题解 | #浙大不同难度题目的正确率#
1,只求浙江大学,difficult_level,result又在其它两表中,因此考虑用inner join连接过滤出三表共同字段的数据来看看 selectup.device_id,up.university,qpd.device_id,qpd.question_id,qpd.result,qd.q...
Mysql
2022-05-11
0
229