var query = (from s in dbo.CadFlange where s.FlaSys='JIS B2220-2004' && s.flatyp ='带颈对焊' && s.flafac='突面(RF)' group s by s.flapre into g select new{ minID= g.Min(p=> p.id), distinctFlapre = g.Distinct(p=> p.flapre) }).OrderBy(x=> x.id) ;