我想要消除重复 distinct却失效了,唉 麻烦啊,请教各位SELECT DISTINCT
NS_ProductPic.NS_ProductID, NS_ProductPic.NS_ProPic,
NS_Product.NS_ProName
FROM NS_ProductPic LEFT OUTER JOIN
NS_Product ON NS_ProductPic.NS_ProductID = NS_Product.NS_ProductID
ORDER BY NS_ProductPic.NS_ProductID DESC
NS_ProductPic.NS_ProductID, NS_ProductPic.NS_ProPic,
NS_Product.NS_ProName
FROM NS_ProductPic LEFT OUTER JOIN
NS_Product ON NS_ProductPic.NS_ProductID = NS_Product.NS_ProductID
ORDER BY NS_ProductPic.NS_ProductID DESC
SELECT DISTINCT
NS_ProductPic.NS_ProductID, NS_Product.NS_ProName
FROM NS_ProductPic LEFT OUTER JOIN
NS_Product ON NS_ProductPic.NS_ProductID = NS_Product.NS_ProductID
ORDER BY NS_ProductPic.NS_ProductID DESC
NS_ProductPic.NS_ProductID, max(NS_ProductPic.NS_ProPic),
NS_Product.NS_ProName
FROM NS_ProductPic LEFT OUTER JOIN
NS_Product ON NS_ProductPic.NS_ProductID = NS_Product.NS_ProductIDgroup by NS_ProductPic.NS_ProductID, NS_ProductPic.NS_ProPic,
NS_Product.NS_ProName
ORDER BY NS_ProductPic.NS_ProductID DESC
SELECT
NS_ProductPic.NS_ProductID, NS_ProductPic.NS_ProPic,
NS_Product.NS_ProName
FROM NS_ProductPic a LEFT OUTER JOIN
NS_Product ON NS_ProductPic.NS_ProductID = NS_Product.NS_ProductID
where not exists(select 1 from ns_productpic where ns_productid=a.nsproductid and NS_ProPic>a.NS_ProPic)
ORDER BY NS_ProductPic.NS_ProductID DESC
babe 不行啊,
SELECT
NS_ProductPic.NS_ProductID, max(NS_ProductPic.NS_ProPic),
NS_Product.NS_ProName
FROM NS_ProductPic LEFT OUTER JOIN
NS_Product ON NS_ProductPic.NS_ProductID = NS_Product.NS_ProductIDgroup by NS_ProductPic.NS_ProductID,NS_Product.NS_ProName
ORDER BY NS_ProductPic.NS_ProductID DESC