1、题目描述
来源:力扣(LeetCode)
2、解题思路
1# 因为是交叉记录的,所以要建一个子表将requester_id,accepter_id
换位置,续在原表后面,用union
函数
2# 然后,倒序取第一个
这里注明:我觉得union
的结果是要去重的,但是letcode的结果是不去重的,所以用union all
3、提交记录
select id,count(*) as num
from(
select requester_id as id,accepter_id as fri
from request_accepted
union all
select accepter_id as id,requester_id as fri
from request_accepted )_add
group by id
order by num desc
limit 1
289ms