回答:死磕:SQL行转列汇总(全网最全最详细) - 知乎 (zhihu.com)
回答:select sum(a) as a,sum(b) as b from(你的SQL)
回答:也不算解决吧,反过来就好了
回答: CASE WHEN SUBSTR("LotId", 1, 13) = SUBSTR(LAG("LotId") OVER(ORDER BY "LotId"), 1, 13) AND SPUTTER_OpCT IS NULL THEN COALESCE(LAG(SPUTTER_OpCT) OVER(ORDER BY "LotId"), LAG(SPUTTER_OpCT, 2) OVER(ORDER BY "LotId"), LAG(SPUTTER_OpCT, 3) OVER(ORDER BY "LotId")) ELSE SPUTTER_OpCT END AS "SPUTTER_OpCT",
回答:双击产品类型单元格-高级-自定义显示-输入公式:if(英文简称 = "hanwen" || 英文简称 = "zhangshan",$$$,"")
回答:把这个数据删掉,在重新添加试一下,我这样就行了
回答:把这个数据删掉,在重新添加试一下,我这样就行了
回答:把这个数据删掉,在重新添加试一下,我这样就行了
8
8
169
10
没有更多