level 1
辉仔0625
楼主
select count(1) from settlement where availably_tag = 0 and insured_kind = '1' and transfer_date between 201301 and 201306
and sum=ACCOUNT_AMNT and trans_place='44!'and typ ='0'
and sum=ACCOUNT_AMNT and trans_place='44!'and typ ='1'
险种 insured_kind = '1' 养老
typ = '0' 转入 '1'转出
transfer_date 转移日期
availably_tag 有效标志
trans_place 转移地方
ACCOUNT_AMNT 求和
请问错在哪了
2013年07月15日 12点07分
1
and sum=ACCOUNT_AMNT and trans_place='44!'and typ ='0'
and sum=ACCOUNT_AMNT and trans_place='44!'and typ ='1'
险种 insured_kind = '1' 养老
typ = '0' 转入 '1'转出
transfer_date 转移日期
availably_tag 有效标志
trans_place 转移地方
ACCOUNT_AMNT 求和
请问错在哪了