TS TARGET SUB_TARGET LOAD 2008-01-01 12:14 192.168.1.1 1a 144 2008-01-02 12:14 192.168.1.1 1b 145 2008-01-03 12:14 192.168.1.1 2a 142 2008-01-04 12:14 192.168.1.1 2b 145 2008-01-05 12:14 192.168.1.2 6s 53 2008-01-06 12:14 192.168.1.2 6t 56 2008-01-07 12:14 192.168.1.2 6u 53 2008-01-08 12:14 192.168.1.2 6v 58 2008-01-09 12:14 192.168.1.3 7a 22 2008-01-10 12:14 192.168.1.4 8a 34 2008-01-11 12:14 192.168.1.5 9a 11 2008-01-12 12:14 192.168.1.6 9g 8 2008-01-13 12:14 192.168.1.7 9h 4 2008-01-14 12:14 192.168.1.8 9i 2 2008-01-01 12:24 192.168.1.1 1a 147 2008-01-02 12:24 192.168.1.1 1b 150 2008-01-03 12:24 192.168.1.1 2a 142 2008-01-04 12:24 192.168.1.1 2b 147 2008-01-05 12:24 192.168.1.2 6s 66 2008-01-06 12:24 192.168.1.2 6t 62 2008-01-07 12:24 192.168.1.2 6u 63 2008-01-08 12:24 192.168.1.2 6v 71 2008-01-09 12:24 192.168.1.3 7a 29 2008-01-10 12:24 192.168.1.4 8a 35 2008-01-11 12:24 192.168.1.5 9a 15 2008-01-12 12:24 192.168.1.6 9g 9 2008-01-13 12:24 192.168.1.7 9h 5 2008-01-14 12:24 192.168.1.8 9i 7
This is the example. I need to sort values and get subtract from sorting first Target, then Subtarget and then Timestamp and return a new column names INC_LOAD --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en -~----------~----~----~----~------~----~------~--~---
