tSQL-查找商店中最小产品的价格

Question

我想找到商店中最小产品的价格，此外，在另一列中，将此价格填充到同一商店的所有产品中。这是我的表格；结果"；列：

表1

这是我的请求，但它没有填充价格：

SELECT local ,product ,price ,IIF(MIN(Product) OVER (PARTITION BY Local)=Product,Price,NULL) as Results FROM Table1

感谢

Answer 1

您可以尝试下面的-

SELECT local, product, price, min(price) OVER (PARTITION BY Local) as result
FROM Table1

Answer 2

如果您想要最小产品的价格：

SELECT local, product, price, MAX(CASE WHEN product=MinProd THEN price ELSE 0 
END) OVER (PARTITION BY Local)Results
FROM
(
SELECT local, product, price, min(product) OVER (PARTITION BY Local) as 
MinProd FROM Table1
)
X