第1个回答 2010-07-02
1.用SQL实现去重
select min(id),b from 表A group by b
2.用C#实现再筛选
DataTable dt = dbHelper.get表A("select id,b from 表A");
DataTable dt1 = dbHelper.get表A("select min(id),b from 表A group by b");
string a = "";
for(int i = 0 ;i<dt1.Rows.Count;i++)
{
a+=dt1.Rows[i]["id"].ToString()+",";
}
dt.Select(" id in ("+a.Trim(',')+")");本回答被提问者采纳