SQL Language (MOSC)

MOSC Banner

How can I get this result using SQL.

edited Jun 8, 2011 9:23PM in SQL Language (MOSC) 4 commentsAnswered
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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center