摘要:
184. 部门工资最高的员工 需要注意的几个点,inner join可以缩减成join,取的是两个表的交集 in关键词,找的是当前所要找的数值是否在指定的范围之中 # Write your MySQL query statement below select d.Name as Department 阅读全文
摘要:
https://leetcode-cn.com/problems/rank-scores/ 178. 分数排名 select s1.Score, count(distinct s2.Score) as Rank from scores as s1, scores as s2 where s1.Sco 阅读全文
摘要:
#include <bits/stdc++.h> using namespace std; const int maxn = 2e5 + 100; int ans = 0; vector<pair<int, bool> >ret; void Search(int n, int val, int po 阅读全文