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()!=””）
{
}
原文：http://www.cnblogs.com/huxu/p/3880421.html