retrieve sql data records in columns instead of rows

Question

How can I do a SELECT statement and have it returned the data incolumns instead of rows?

FROM

+----+-------+--------+
| id | name  | number |
+----+-------+--------+
|  0 | test  |     11 |
|  1 | test2 |     12 |
+----+-------+--------+

TO

+----+------+--------+----+-------+--------+
| id | name | number | id | name  | number |
+----+------+--------+----+-------+--------+
|  0 | test |     11 |  1 | test2 |     12 |
+----+------+--------+----+-------+--------+

Answer 1

Look up 'pivot table' in the help files for your database engine.

Answer 2

pobably you are searching this function:

mysql> SELECT student_name,
    ->     GROUP_CONCAT(test_score)
    ->     FROM student
    ->     GROUP BY student_name;

http://dev.mysql.com/doc/refman/5.0/en/group-by-functions.html#function_group-concat

Answer 3

You really don't want to do that in SQL - I'm not even sure that any decent DBMS would allow such a thing!