失败的cc

题解

Canal(1) Flume(1) Hadoop(1) HBase(1) Hive与数据仓库(3) Java并发编程(5) Java知识(5) JVM(4) Kudu(1) Linux(2) MySQL(2) Phoenix(1) Scala(3) Spark(1) 算法与数据结构个人总结(2) 编程思想(1) 英语(3)

/ 注册

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

创建临时表

with tmp_table as ( select t1.id, t1.name, sum(t2.grade_num) as grade_sum from user as t1 join grade_info as t2 on t1.id = t2.user_id ...

mysql

2021-04-06

43 2319

一遍Hash即可完成任务

import java.util.*; public class Solution { public int[] twoSum (int[] numbers, int target) { int[] result = new int[2]; Map<I...

数组哈希

2020-12-22

50 1504

Mysql窗口函数解法

select distinct user_id, last_value(date) over(partition by user_id order by date rows between current row and unbounded following) as d from ...

窗口函数 mysql

2020-12-19

30 2980

用sum直接计算失败的个数

select date, round(sum(type = "no_completed") / count(*), 3) as p from email as t1 join user as t2 on t1.send_id = t2.id join user as t3 on t1...

mysql

2020-12-19

98 3733

两种解法

// public class TreeNode { // int val = 0; // TreeNode left = null; // TreeNode right = null; // } // 1. 先求出中序遍历，然后根据中序遍历的结果求出异常值 import ...

递归树

2020-12-16

17 827

递归迭代双解法

import java.util.*; /* * public class TreeNode { * int val = 0; * TreeNode left = null; * TreeNode right = null; * } */ public class Sol...

递归树迭代

2020-12-16

3 616