81,091
社区成员
发帖
与我相关
我的任务
分享
String sql="select card_id,(select sum (acc_num) from " +
" t_rm_vip_acclist where card_id=t.card_id and " +
" ope_date < '2009-12-31 23:59:59.9' and oper_type=0) " +
" as sumjf,(select sum (acc_num) from " +
" t_rm_vip_acclist where card_id=t.card_id and " +
" ope_date >'2010-1-1 00:00:00' and oper_type=3)" +
" as sumkj,(select sum (acc_num) from " +
" t_rm_vip_acclist where card_id=t.card_id and " +
" ope_date > '2010-1-1 00:00:00' and oper_type=0) as sum10jf" +
" from t_rm_vip_acclist t group by card_id";