帮写一个sql语句

[lesni]

帮写一个sql语句，
数据是这样的：
aaaa
bbbb
cccc
dddd
结果是这样的：
aaaa
aaaa
aaaa
bbbb
bbbb
bbbb
cccc
cccc
cccc
dddd
dddd
dddd
就是说相同行重复三遍

[ljian_mail]

select
(select distinct xx from table
union all
select distinct xx from table
union all
select distinct xx from table

[ljian_mail]

select xx from
(select distinct xx from table
union all
select distinct xx from table
union all
select distinct xx from table
) a order by xx