Home -> Usenet -> comp.databases.oracle -> Re: tricky SQL query (currently handled through PL/SQL)

Re: tricky SQL query (currently handled through PL/SQL)

From: Jetlag <jetlag11235_at_yahoo.com>
Date: 11 Jun 2003 14:51:04 -0700
Message-ID: <2eeed00e.0306111351.149538f6_at_posting.google.com> 







Ahh, I see where my example could lead to some confusion.  An
augmented example is included below.  Note the re-occurrance of the
value 1 for my_code.  There are now two records in the output table
with this value, and this is why a simple "group by" statement will
not suffice.  Apologies for the confusion.



For example, consider this (new) example data in my_table_v1:


    1   '01/01/03 00:00:00'   1
    1   '01/01/03 00:00:01'   1
    1   '01/01/03 00:00:04'   1
    1   '01/01/03 00:00:05'   3
    1   '01/01/03 00:00:09'   2
    1   '01/01/03 00:00:15'   2
    1   '01/01/03 00:00:20'   1
    1   '01/01/03 00:00:24'   1
 




This should become the following in my_table_v2:


    1   '01/01/03 00:00:00'   '01/01/03 00:00:04'   1
    1   '01/01/03 00:00:05'   '01/01/03 00:00:05'   3
    1   '01/01/03 00:00:09'   '01/01/03 00:00:15'   2
    1   '01/01/03 00:00:20'   '01/01/03 00:00:24'   1





    
  
  •   jetlag --



Received on Wed Jun 11 2003 - 23:51:04 CEST












Original text of this message