Question

oracle合计语句怎么写

怎么写语句把图一变成图二，第二列为合计数





Answer 1

select ACCOUNT_ID,sum(ADC) AS ADC from 表名 group by ACCOUNT_ID;
这样写试一下，看看是否好用。

Answer 2

"What can I do?" the wolf is sad.