trySelect * From 表 Where a In
(Select a From
(Select a, b As Value From 表
Union All
Select a, c As Value From 表
Union All
Select a, d As Value From 表
Union All
Select a, e As Value From 表
Union All
Select a, f As Value From 表
Union All
Select a, g As Value From 表) A
Group By a Having Count(Distinct value) > 1)
(Select a From
(Select a, b As Value From 表
Union All
Select a, c As Value From 表
Union All
Select a, d As Value From 表
Union All
Select a, e As Value From 表
Union All
Select a, f As Value From 表
Union All
Select a, g As Value From 表) A
Group By a Having Count(Distinct value) > 1)
Select * From 表 Where a In
(Select a From
(Select a, b As Value From 表
Union All
Select a, c As Value From 表
Union All
Select a, d As Value From 表
Union All
Select a, e As Value From 表
Union All
Select a, f As Value From 表
Union All
Select a, g As Value From 表) A
Where Value Is Not Null
Group By a Having Count(Distinct value) > 1)
同意
是字段类型的问题?
是varchar不行吗?好像必须是varchar啊,因为不仅仅有数字,还有数字与字母的组合
为什么我的值明明是相同的,还列出?
是字段类型的问题?
是varchar不行吗?好像必须是varchar啊,因为不仅仅有数字,还有数字与字母的组合
------------
哪個語句?
但是如下这种样式:
a b c d e f g
-------------------------------------------
001 04008 04008 04008按我的要求这样的结果是不应该显示出来的啊
注明b-g字段类型是varchar(8000)这个类型是不能变的,老大帮我看看是哪里问题?
fa_ge(鶴嘯九天),你怎麼亂同意?!g<>null這種寫法OK嗎?
----------------
應該 isnull(g,'')<>''
哈哈恭喜魚兄升星了
AND isNull(A,'')<>'' and isNull(B,'')<>'' and isNull(C,'')<>'' and isNull(D,'')<>''
and isNull(E,'')<>'' and isNull(F,'')<>'' and isNull(G,'')<>''
(Select a From
(Select a, b As Value From 表
Union All
Select a, c As Value From 表
Union All
Select a, d As Value From 表
Union All
Select a, e As Value From 表
Union All
Select a, f As Value From 表
Union All
Select a, g As Value From 表) A
Where IsNull(Value, '') != ''
Group By a Having Count(Distinct value) > 1)
顺便也放分,只是分太少,别介意啊