SELECT id, concat( name, name2, name3 ) AS name , concat( name, name2, name3 ) AS name2 , concat( name, name2, name3 ) AS name3 FROM testaa 用这种方式显示的结果,这不是我想要的,请高手指点一下,谢谢! id name name2 name3 1 aa aa aa 1 bb bb bb 1 cc cc cc
select id ,max(name),max(name2),max(name3) from testaa group by id
, concat( name, name2, name3 ) AS name2
, concat( name, name2, name3 ) AS name3
FROM testaa
用这种方式显示的结果,这不是我想要的,请高手指点一下,谢谢!
id name name2 name3
1 aa aa aa
1 bb bb bb
1 cc cc cc