For more information about mysql output

For more information about mysql output, see table sn & nbsp; name & nbsp; & nb mysql output question. could you please refer
Table

Sn name sub time

1 Wang 1 math 2012-1-1 1-1

2 Wang 2 Chinese language 2012-1-1

5 Wang 3 Sports

4 Wang 4 science 2012-1-2 2

Output

2012-1-1

Chinese

Mathematics

2012-1-2

Sports

Science

Note: The content corresponding to the time output should be put together.

------ Solution --------------------
Select time, group_concat (sub) from tableName group by time