select * from transinfo where type='支取' order by money;
select * from transinfo where remark is null order by transDate desc;
select * from transinfo where type='转入'or type='转出';
select * from transinfo where transDate between '2019-7-5 00:00:00'and '2019-7-5 23:59:59' ;
select * from transinfo where cardNo='002'and (transDate between '2019-6-20 00:00:00'and '2019-6-20 23:59:59');
select * from transinfo where type='转出' and money>500;