select*from transInfo where type='支取' order by money asc select*from transInfo select*from transInfo where remark='' order by transDate asc select type,money from transInfo select * from transInfo where transDate like '2019-07-05%' and money; select*from transInfo where cardNo='002' and transDate like '2019-06-20%' select*from transInfo where money>500