------------------------------------------------------------------------------------------------------------------------------------100011 | FA | 50 |100011 | FA | 100
我正在处理一个复杂的sql查询。(SUM(d.paid_amt) OVER (PARTITION BY a.some_column),0) as amount_paid
from a Inner join b on b.column3但是,我试图以这样的方式编写查询:如果d表用where条件d.column5 = a.column1复述任何值,那么我想使用这些值,或者如果d表中没有记录,我只想从先前联接的结果中获取记录,并得到我需要的记录am ount计算也
正如您在下面的代码中所看到的,我想知道是否有一些SQL函数可以找到id是唯一的东西的和,例如?
SELECT a.userid, u.name, u.profilePic ,
//sum the points when the activity_typeid is unique and make an extra column for e
Column_3 ..Column_d
x*(f1*f1)/(Other1*Other1) x*(f1*f2)/(Other1*Other2) x*(f1*f3)/(Other1(1) AS x, sum(a+b) as f1,pow(b,c) as f2....,sum(x+y) as Other1 ,pow(y+z) as Other</em