select distinct a from table5
union
select distinct b from table5
union
select distinct c from table5
union
select distinct d from table5
union
select distinct b from table5
union
select distinct c from table5
union
select distinct d from table5
--------------------------------------------------------
ip1 mib1 port1 index1 ......................(值忽略)
ip3 mib4 port1 index1 ......................(值忽略)
ip5 mib1 port2 index3 ......................(值忽略)
ip1 mib1 port1 index1 ......................(值忽略)
ip4 mib2 port3 index3 ......................(值忽略)
ip1 mib4 port1 index1 ......................(值忽略)
ip5 mib1 port1 index1 ......................(值忽略)
ip1 mib3 port1 index2 ......................(值忽略)
ip1 mib4 port3 index1 ......................(值忽略)
ip1 mib2 port1 index1 ......................(值忽略)
ip4 mib1 port1 index2 ......................(值忽略)
ip1 mib3 port1 index1 ......................(值忽略)
ip1 mib1 port3 index1 ......................(值忽略)
ip5 mib2 port1 index1 ......................(值忽略)
ip1 mib1 port3 index1 ......................(值忽略)
ip4 mib3 port1 index1 ......................(值忽略)
ip1 mib4 port1 index5 ......................(值忽略)
ip5 mib1 port1 index1 ......................(值忽略)
ip4 mib2 port1 index4 ......................(值忽略)
ip1 mib1 port2 index1 ......................(值忽略)
ip5 mib3 port1 index3 ......................(值忽略)
ip3 mib1 port2 index1 ......................(值忽略)
ip1 mib1 port1 index1 ......................(值忽略)..
..
..需要得到如下实例:
---------------------------------
ip1 mib1 port1 index1
ip1 mib1 port1 index2
ip1 mib1 port2 index1
ip1 mib1 port2 index3
ip1 mib2 port1 index1
ip1 mib2 port2 index2
ip2 mib1 port1 index1
ip2 mib1 port1 index2。。
。。
。。用上面的SQL语句可以吗?
group by 分组是可以,也就是select a,b,c,d from table group up a,b,c,d
是正确的
要求得到的实例中,每一行中(一行有a,b,c,d四个元素)总有至少一个元素与其它行相应的元素不重复
应该怎么写呢?谢谢!
SELECT TABLE5_1.b, TABLE5_2.c, TABLE5_3.d, dbo.TABLE5.a
FROM dbo.TABLE5 CROSS JOIN
dbo.TABLE5 TABLE5_1 CROSS JOIN
dbo.TABLE5 TABLE5_2 CROSS JOIN
dbo.TABLE5 TABLE5_3
GROUP BY TABLE5_1.b, TABLE5_2.c, TABLE5_3.d, dbo.TABLE5.a