首页 > 试题广场 >

SQL题目：

[问答题]
SQL题目：





















添加回答
石开123头像 石开123 
with x as (select distinct fuser from t_user), y as (select distinct fuser from t_user), a as (select  x.fuser as fuser1,y.fuser as fuser2 from  x join y on x.fuser<y.fuser  ), b as (select  x1.fuser as fuser1,y1.fuser as fuser2, count(distinct y1.fprod) as sim_cnt from t_user x1 join t_user y1 on  x1.fuser<y1.fuser  and  x1.fprod=y1.fprod  group by  x1.fuser,y1.fuser)  select b.fuser1,b.fuser2,b.sim_cnt from a left join b on a.fuser1=b.fuser1 and  a.fuser2=b.fuser2
发表于 2018-12-18 09:31:46 回复(1)
提交观点

问题信息

运维工程师 算法工程师 乐信 2019 滴滴
来自：2019校园招聘算法工...
上传者：小小
难度：
1条回答 2948浏览

热门推荐

相关试题

扫一扫，把题目装进口袋

求职之前，先上牛客

扫描二维码，进入QQ群

扫描二维码，关注牛客公众号