求一MySql查询语句SQL codetable a:aid na nb012113232查询结果：nab123结果为字段na和字段nb的记录去除重
求一MySql查询语句
- SQL code
table a:aid na nb0 1 21 1 32 3 2查询结果：nab123
结果为字段na和字段nb的记录去除重复后的汇总。
[解决办法]
- SQL code
select nabfrom (select na as nab from aunionselect nb as nab fromm a)Torder by T.nab
[解决办法]
错了
- SQL code
select nabfrom (select distinct na as nab from aunionselect distinct nb as nab fromm a)Torder by T.na
[解决办法]
没有其它好方法了。