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能不能指定针对一个字段的检查的
皇帝胡搞是游龙戏凤，
巡抚胡搞是深入群众，
知府胡搞是娱乐活动，
知县胡搞是体育运动，
小吏胡搞是胡乱打洞，
草民胡搞是流氓活动
============================
有客自东来,告我沈阳事,
甲申今岁无他论,唯庆清军入汉关.
闻客闲言做冷笑,长夜孤坐难入眠,
酒尽十杯心愈寒,弹剑金樽前,
杜鹃涕泣星月残,国耻激心阑.
昔时中国内战急,满奴乘间夺汉室,
中外当一家,留发不留头,
南来屠城九十九,汉血染尽汉河山.
读史至此不忍言,历史一长叹,
二百年来为猪狗,汉家英雄起报仇,
百万人头落,争得自由身.
三代安乐忘羞耻,白日繁星乌云连,
洪贼施逆成英豪,扬州十日内战篇,
豚尾大戏日日歌,万家迷倒满装前.
千载精忠事,不值一文钱,
武穆文山皆迂朽,好个智者余桂圆.
黄花冈上看黄花,黄花零落意沉沉,
十万万人齐倒戈,今日中国无汉人.
| -ICP -IDC -ISP |