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

在做二岸快捷之时，因为用户要上传文档，怎么办啊？我在数据库里做了多个值，反正的的便保存，未上传者便为空。

			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

查询是，灵感源于此。 点击打开链接

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>