SQL高手进！！！急...在线等~！

来源：百度知道 编辑：UC知道 时间：2024/06/03 16:35:54
SELECT TOP (1) id, productid, price, uid, time
FROM Bid
WHERE (price NOT IN
(SELECT price
FROM Bid AS Bid_1
GROUP BY price
HAVING (COUNT(*) > 1)))
ORDER BY price

这样可以查出最低且唯一的一条数据·请问怎么加才能做到查一段时间内最低且唯一的数据呢？？？

SELECT TOP (1) id, productid, price, uid, time
FROM Bid
WHERE (price NOT IN
(SELECT price
FROM Bid AS Bid_1
GROUP BY price
HAVING (COUNT(*) > 1))) and time>'' and time <''
ORDER BY price

加个and time>'' and time <'' 就行了