How can I get this result using SQL.
Hello, once again with the same problem.
I have this data in a table (bustinza):
r303 resulttime r100
----------- --------------------------------- ----------
205M 03/06/2011 17:49:32 16,03
205M 03/06/2011 17:49:52 21,11
205M 03/06/2011 17:50:07 15,19
250M 03/06/2011 17:47:32 12,03
250M 03/06/2011 17:48:52 31,11
250M 03/06/2011 17:49:07 15,00
The result I need is:
r303 time1 r100_1 time2 r100_2 time3 r100_3
----------- -------------------------- ------------- ------------------------- ---------- ------------------------- -----------
205M 03/06/2011 17:49:32 16,03 03/06/2011 17:49:52 21,11 03/06/2011 17:50:07 15,19
250M 03/06/2011 17:47:32 12,03 03/06/2011 17:48:52 31,11 03/06/2011 17:49:07 15,00
Thanks in advance.
bye
I have this data in a table (bustinza):
r303 resulttime r100
----------- --------------------------------- ----------
205M 03/06/2011 17:49:32 16,03
205M 03/06/2011 17:49:52 21,11
205M 03/06/2011 17:50:07 15,19
250M 03/06/2011 17:47:32 12,03
250M 03/06/2011 17:48:52 31,11
250M 03/06/2011 17:49:07 15,00
The result I need is:
r303 time1 r100_1 time2 r100_2 time3 r100_3
----------- -------------------------- ------------- ------------------------- ---------- ------------------------- -----------
205M 03/06/2011 17:49:32 16,03 03/06/2011 17:49:52 21,11 03/06/2011 17:50:07 15,19
250M 03/06/2011 17:47:32 12,03 03/06/2011 17:48:52 31,11 03/06/2011 17:49:07 15,00
Thanks in advance.
bye
0