¹ØÓÚSqlÓï¾ä ¸ßÊÖÀ´¿´¿´ - .NET¼¼Êõ / ASP.NET

SQL code:

SELECT t1.brid,t1.productId,t1.sellerId,t1.price,t1.inputDt from
(SELECT *from dbo.vw_BidReply_list WHERE bid=7) t1,
(SELECT MIN(price) AS minPrice,productId from dbo.vw_BidReply_list a WHERE bid=7 GROUP BY productId
) t2
WHERE t1.price=t2.minPrice AND t1.productId=t2.productId

--brid--price--productId--sellerId------inputdate
--19----2.02----34----------43----------2010-02-24 16:34:42.25
--18----0.79----22----------25----------2010-02-24 16:34:41.25
--13----0.79----22----------43----------2010-02-24 16:34:44.25


ÔõôµÃµ½ÏÂÃæµÄÁ½ÌõÊý¾Ý,×¢ÒâÈÕÆÚ
--brid--price--productId--sellerId------inputdate
--19----2.02----34----------43----------2010-02-24 16:34:42.25
--18----0.79----22----------25----------2010-02-24 16:34:41.25

---

SQL code:
select * from (SELECT t1.brid,t1.productId,t1.sellerId,t1.price,t1.inputDt from
(SELECT *from dbo.vw_BidReply_list WHERE bid=7) t1,
(SELECT MIN(price) AS minPrice,productId from dbo.vw_BidReply_list a WHERE bid=7 GROUP BY productId
) t2
WHERE t1.price=t2.minPrice AND t1.productId=t2.productId) C group by sellerId
having inputdate=max(inputdate)
ÊÔÊÔÕâÖÖÐв»ÐÐ

---

ʲôÒâ˼£¿È¡Ê±¼äСµÄÁ½Ìõ£¿