select * from transinfo where type='支取' order by money asc;
select * from transinfo where remark is null order by money desc;
select * from transinfo where type in ('转入','转出');
select * from transinfo where transDate like '2019-07-05%';
select * from transinfo where transDate like '2019-06-20%' and cardNo='002';
select * from transinfo where type='转出'and money>500;