SELECT b.Name AS Name, c.Company_Name AS CompanyName, c.State AS State,
a.Deep AS Deep
FROM Contract a LEFT OUTER JOIN
Floor_Office b ON a.Floor_Office_ID = b.ID LEFT OUTER JOIN
Company c ON a.Lessee = c.Company_Name
WHERE (b.Build_ID = '1') AND (b.Property_ID = '1') AND (a.DeleteFlg = 1) AND
(b.DeleteFlg = 1) AND (c.DeleteFlg = 1) AND (c.If_Cn = 1)
ORDER BY b.Name, a.Deep DESC

出来的结果是

Name CompanyName State Deep
==================================
102乙 88啊111 4 -1
1111 888888 5 0
123 oneforever 0 0 <--
205 chenuxjun119 0 0
212 oneforever 0 1 <--
212 891532第 0 0
302 81038488 2 0
601A 1234567890 0 0

问题是这样，希望上面companyname相同的记录只出来1条，
不知道distinct能不能指定针对一个字段的检查的