不重复查询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()!=””）

{ 

}