Sorting problem... session & time
Hello
Lets say you have data like this:
Time Sessionid
20.55 a1
20.44 a1
20.39 x3
20.33 x3
20.29 a1
20.27 a1
and you want to sort it so it looks like this i.e. grouped according to Sessionid and then Time:
a1 = 20.55 20.44 20.29 20.27
x3 = 20.39 20.33
What is the best way to do this in mySQL?
Thank you.
Hello
Lets say you have data like this:
Time Sessionid
20.55 a1
20.44 a1
20.39 x3
20.33 x3
20.29 a1
20.27 a1
and you want to sort it so it looks like this i.e. grouped according to Sessionid and then Time:
a1 = 20.55 20.44 20.29 20.27
x3 = 20.39 20.33
What is the best way to do this in mySQL?
Thank you.