我在SQL Server2008上使用以下SQL查询从products和categories表中选择行。
SELECT products.idProduct, sku, description, listPrice,
smallImageUrl, isBundleMain, rental, visits
FROM products, categories_products
WHERE products.idProduct = categories_products.idProduct
AND categories_products.idCategory = "& pIdCategory&"
AND listHidden=0
AND active=-1
AND idStore = " &pIdStore& "
ORDER BY description问题是有些行是重复的。这些重复项通常由products.idProduct列确定,因此我希望更改查询,以便相同的products.idProduct不会出现两次,例如,其中一行具有products.idProduct = 3438,另一行具有相同的产品id,只显示一个products.idProduct
发布于 2013-03-14 02:47:45
您需要使用distinct。请在下面尝试
SELECT distinct
products.idProduct, sku, description, listPrice, smallImageUrl,
isBundleMain, rental, visits
FROM products, categories_products
WHERE products.idProduct=categories_products.idProduct
AND categories_products.idCategory="& pIdCategory&"
AND listHidden=0 AND active=-1
AND idStore=" &pIdStore& "
ORDER BY description发布于 2013-03-14 02:49:35
使用
DISTINCT如下所示:
SELECT DISTINCT products.idProduct,
sku, description, listPrice,
smallImageUrl, isBundleMain, rental, visits
FROM products, categories_products
WHERE products.idProduct = categories_products.idProduct
AND categories_products.idCategory = "& pIdCategory&"
AND listHidden = 0 AND active = -1
AND idStore =" &pIdStore& "
ORDER BY description发布于 2013-03-14 02:51:05
在字段的select查询中使用DISTINCT。
https://stackoverflow.com/questions/15393833
复制相似问题