求一sql语句
如何将查询出的两列数据合并成一列并去重,如图:midnid
3364316681
3364317530
3364362856
2182208752
2182209431
合并后的
33643
2182
16681
17530
62856
208752
209431
数据已经查询出来了?那么对结果就不能再用SQL了
如果是在数据库中的两列的话,可以用每列select然后union(会自动将重复的元组去掉) ... SELECT mid as t FROM eee e
union
SELECTnid as t FROM eee e SELECT mid as t FROM eee e
union
SELECTnid as t FROM eee e
页:
[1]