select 1列可以匹配多列

Question

I have the 1 table (tblcsv) in database that have data as below:

fieldA  fiel B
aaaa    1

aaaa    2

aaaa    4

a       1

aaaa    2

a       3

bbbb    4

b       3

bbbb    4

b       3

What I need to display:

aaaa        1
            2
            4
            2
a           1
            3
bbbb        4
            4
b           3
            3

I really do not know how to write mysql for query it from database to display what I need.Anyone help me please, Thanks.

Answer 1

select fieldA , fiel B from table 
order by fieldA ;