Re: [SQL] 面试碰到一题不会QQ

楼主: cutekid (可爱小孩子)   2019-12-04 17:43:18
https://imgur.com/a/FwQKjzz
select userid,B.type,
sum( case when A.type = B.type then A.revenue else 0 end )
from A cross join B
group by userid,B.type
order by userid
※ 引述《deniel367 (dann)》之铭言:
: https://i.imgur.com/Gh8nZjG.jpg
: 如图,给定两个表,任务是产生一个表,该表必须包含每个人每个种类的交易记录(若有
: 多笔则加总),如无交易记录,则为0
: 请问这题SQL query该怎么写?感谢!

Links booklink

Contact Us: admin [ a t ] ucptt.com