求一条查询语句!
ykren 2007-06-06 01:53:02 PhotoID ShopID PhotoName PhotoDefault AddDate
----------- ----------- ---------------- ------------ --------------------
8 76 4164022546.jpg 0 2007-06-04 16:40:00
9 53 4164215171.jpg 0 2007-06-04 16:42:00
10 53 4164612343.jpg 1 2007-06-04 16:46:00
11 53 4164655671.jpg 0 2007-06-04 16:47:00
12 53 417650828.jpg 0 2007-06-04 17:07:00
13 3 4223634562.jpg 0 2007-06-04 22:37:00
14 76 422395162.jpg 0 2007-06-04 22:40:00
ShopID中相同的数值只保留一条,满足保留的条件为:PhotoDefault为最大值,或者AddDate为最大值。