最新 最热

临床样本组学研究Day3--RNA 及转录组学研究(ncRNA )

非编码RNA(non-coding RNA)包括micro RNA,long non-coding RNA,circular RNA,pi RNA等,它们不像蛋白质,可以作为生命活动的直接承担者,有关非编码RNA组学的研究也不能像蛋白分子或者基因分子一样仅仅做定量研究。...

2022-02-28
3

Leetcode 题目解析之 Kth Largest Element in an Array

Find the kth largest element in an unsorted array. Note that it is the kth largest element in the sorted order, not the kth distinct element.

2022-02-14
1

MySQL最常用分组聚合函数

1)当使用组函数的select语句中没有group by子句时,中间结果集中的所有行自动形成一组,然后计算组函数;

2022-02-11
1

Leetcode 题目解析之 Remove Duplicates from Sorted List II

Given a sorted linked list, delete all nodes that have duplicate numbers, leaving only distinct numbers from the original list.

2022-01-14
3

Leetcode 题目解析之 Subsets

Given a set of distinct integers, nums, return all possible subsets.

2022-01-10
1

数据库基础(四) Sql语句速查(转)

order by 对查询结果排序[课程号从大到小排列:降序desc]; asc是升序排列

2022-01-10
1

Leetcode 题目解析之 Contains Duplicate III

Given an array of integers, find out whether there are two distinct indices i and j in the array such that the difference between numsi and numsj is at most t a...

2022-01-08
1

Leetcode 题目解析之 Contains Duplicate II

Given an array of integers and an integer k, find out whether there are two distinct indices i and j in the array such that numsi = numsj and the difference bet...

2022-01-08
1

抖音面试题:遇到连续问题怎么办?

我在《拼多多面试题:如何找出连续出现N次的内容?》里讲过遇到“连续问题”如何解决,并送出了一个万能模板,模板使用的是窗口函数解决连续问题。...

2022-01-05
1

索引离散性 && 最左匹配原则

列的离散性(可以理解为差异性)=count(distinct col ) / count(col)

2021-12-22
1