过滤反复数据
日期：2014-05-17 浏览次数：20651 次
过滤重复数据
字段1 ListClothID 字段2 ListClothImageSmall
1 222
1 333
1 444
2 555
2 ddd
3 f
3 v
想得到 1 222
2 555
3 f
select a.ListClothID , b.ListClothImageSmall
from (select distinct ListClothID from ListClothImage) as a left join ListClothImage b on a.ListClothID = b.ListClothID
------解决方案--------------------
字段1 ListClothID 字段2 ListClothImageSmall
1 222
1 333
1 444
2 555
2 ddd
3 f
3 v
想得到 1 222
2 555
3 f
select a.ListClothID , b.ListClothImageSmall
from (select distinct ListClothID from ListClothImage) as a left join ListClothImage b on a.ListClothID = b.ListClothID
------解决方案--------------------
- SQL code
SELECT ListClothID,
ListClothImageSmall
FROM (SELECT Row_number()
OVER(
ORDER BY a.ListClothID )rn,
a.ListClothID,
b.ListClothImageSmall
FROM (SELECT DISTINCT ListClothID
FROM ListClothImage) AS a
LEFT JOIN ListClothImage b
ON a.ListClothID = b.ListClothID)b
WHERE rn = 1
------解决方案--------------------
- SQL code
SELECT ListClothID,
ListClothImageSmall
FROM (SELECT Row_number()
OVER(
ORDER BY a.ListClothID )rn,
a.ListClothID,
b.ListClothImageSmall
FROM (SELECT DISTINCT ListClothID
FROM ListClothImage) AS a
LEFT JOIN ListClothImage b
ON a.ListClothID = b.ListClothID)b
WHERE rn = 1
免责声明： 本文仅代表作者个人观点，与爱易网无关。其原创性以及文中陈述文字和内容未经本站证实，对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺，请读者仅作参考，并请自行核实相关内容。
