在做二岸快捷之時(shí)，因?yàn)橛脩粢蟼魑臋n，怎么辦?。课以跀?shù)據(jù)庫里做了多個(gè)值，反正的的便保存，未上傳者便為空。

id number hblfile hbltxlfile mblfile mbltxlfile loadingfile op input

			1	2012050002		222	222
			6	2012050002	120522-09-53-520.xls		4			11010	20120522095352
			7	2012050002		Yes				11010	20120522095352
			8	2012050002			120522-09-53-521.php			11010	20120522095352
			9	2012050002	dfdfdf		66
			10	2012050002	dfaffffaafsf

查詢是，靈感源于此。 點(diǎn)擊打開鏈接

    select * from attfile A where not exists (selct * from attfile where num
ber=A.number and hbltxlfile > A.hbltxlfile)//
+----+------------+---------+------------+---------+------------+----------
------+----------------+
| id | number     | hblfile | hbltxlfile | mblfile | mbltxlfile | loadingfi
op    | input          |
+----+------------+---------+------------+---------+------------+----------
------+----------------+
|  7 | 2012050002 |         | Yes        |         |            |
11010 | 20120522095352 |
+----+------------+---------+------------+---------+------------+----------
------+----------------+
1 row in set (0.00 sec)


mysql>
  

多值并列求最大者策略，要使用exists