EASYBOOR

<br /><br />1 GROUP_CONCAT<br />mysql> SELECT student_name,<br />    ->     GROUP_CONCAT(test_score)<br />    ->     FROM student<br />    ->     GROUP BY student_name;<br />Or: <br />mysql> SELECT student_name,<br />    ->     GROUP_CONCAT(DISTINCT test