分类聚合统计

 

SELECT

user_id,

SUM(CASE when tx_type='1' then tx_amount else 0 end) as charge,

SUM(CASE when tx_type='2' then tx_amount else 0 end) as withdraw

FROM

T_TX_DETAIL

WHERE

TX_STATUS = '2'

GROUP BY

USER_ID