请教一下,去重求和的脚本,如何写,
sql如下:
select
sum(b.a)
from
(select distinct id ,amount as a from trade) as b
麻烦写个 es脚本的例子,谢谢.
例如图片中.对trade_no 进行去重,统计去重后的money和
sql如下:
select
sum(b.a)
from
(select distinct id ,amount as a from trade) as b
麻烦写个 es脚本的例子,谢谢.
例如图片中.对trade_no 进行去重,统计去重后的money和
3 个回复
JiangJibo - 喊我雷锋
赞同来自: ge00111
ge00111 - 三人行必有我师
赞同来自:
ge00111 - 三人行必有我师
赞同来自: