~~~sql 小问题(在线等！)

Question

table1字段：  username userpass type        sun       sun     yy
        sun       sun     yy
        po        po      uu
        po        po      uu如何将内容重复的列合为一列
实现后：
        sun      sun       yy
        po       po        po

Answer 1

select distinct  username, userpass, type from table1

Answer 2

select distinct(*) from table1

Answer 3

sun      sun       yy
po       po        po
看不出规律，再多点数据楼主

Answer 4

select distinct * from table1