How do I get the right 2 dimensional array for this table in H2?

Question

This is my H2 table.

I need to write a SQL query that fetches the result like so:

How do I fetch it this way? Is this possible?

Do you have only two values for each step or can you have more? — Marco, Nov 21 '11 at 07:22
These are test results. So if there are ten steps and the test was executed 5 times, then I would have Step 1 through 10 five times along with the time taken for each of those steps — dkulkarni, Nov 21 '11 at 07:23
This is a specific instance of [this question](http://stackoverflow.com/questions/102317/how-to-get-multiple-records-against-one-record-based-on-relation/106334) — mdahlman, Nov 21 '11 at 07:33

score 2 · Accepted Answer · answered Nov 21 '11 at 07:24

If you have more than two values for each step, you could do

SELECT step_col, GROUP_CONCAT(time_col)
FROM H2 GROUP BY step_col

Then you can easily split time_col values in your code.
Check GROUP_CONCAT syntax to understand how you can use it the way you please.

1 Answers1