1

I am trying to get multiple column data returned in a single row. I have a table like this:

NAME TESTCASE DATE       TIME
DC   abc      2014-04-03 0.063
DC   abc      2014-07-17 0.057
DC   def      2014-04-03 0.051
DC   def      2014-07-17 0.078

I want to get table output like this:

NAME TESTCASE TIME_01 TIME_02 
DC   abc      0.063   0.057   
DC   def      0.051   0.078

I tried to use GROUP_CONCAT(TIME), but i could not get data in seperate columns TIME_01 and TIME_02. Also i could not get second row of data.

Any help is appreciated. Thanks

Improve this question
3
  • you may see stackoverflow.com/questions/3288014/… Commented Aug 17, 2014 at 18:25
  • Thanks Fisherman, this is helpful. Commented Aug 18, 2014 at 4:26
  • I am curious, i got multiple comments/Answer from another user (Juergen D) 8 hrs ago, but i am not seeing his comments/Amswer now. I don't know how they got deleted? Commented Aug 18, 2014 at 4:29
Related questions
8
Mysql return more than one row
0
Retrieve all row data using a GROUP_CONCAT
0
MySQL Query SELECT multiple rows
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.