|
select a.[交易类型( Transaction Type )],a.[付款人名称( Payer's Name )],a.[交易日期( Transaction Date )],a.[交易金额( Trade Amount )] from [多账户查询业务处理结果$a14:z] a inner join (select [交易类型( Transaction Type )],[付款人名称( Payer's Name )],[交易日期( Transaction Date )],[交易金额( Trade Amount )] from [多账户查询业务处理结果$a14:z] where [交易类型( Transaction Type )]='往账' and [交易金额( Trade Amount )]<50000 group by [交易类型( Transaction Type )],[付款人名称( Payer's Name )],[交易日期( Transaction Date )],[交易金额( Trade Amount )] having count(*)>1) b on a.[交易类型( Transaction Type )]=b.[交易类型( Transaction Type )] and a.[付款人名称( Payer's Name )]=b.[付款人名称( Payer's Name )] and a.[交易日期( Transaction Date )]=b.[交易日期( Transaction Date )] and a.[交易金额( Trade Amount )]=b.[交易金额( Trade Amount )] |
|