首页 > 代码库 > 不重复查询mysql

不重复查询mysql

select EquipmentSID,MIN(MatureTime),MIN(ISlock) from table group by name

 

String sql =” Select * from EM_INFO WNERE USERNAME like‘%”+ tbname.text.trim() + “%’  and  sex  like‘%” + tbsex.text.trim() + “%’” 

If(tbname.text.trim()!=”” && tbsex.text.trim()!=””)

}