Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Find the first record, for every day

Re: Find the first record, for every day

From: <ohahaahr_at_hotmail.com>
Date: 21 Dec 2005 02:43:37 -0800
Message-ID: <1135161817.393305.228590@f14g2000cwb.googlegroups.com>


There is no difference. The to dates are the same. (No difference in time).

What you see is a result of a complex query. If the date is confusing, we could change the case to this:

Name Status Rownum
------ ------- ------

OLE     2       1
OLE     1       2
PETER   1       3
JOHN    2       4
JOHN    10      5

And then the output should look like this:

Name Status Rownum
------ ------- ------

OLE     2       1
PETER   1       3
JOHN    2       4

Regards,
Ole Received on Wed Dec 21 2005 - 04:43:37 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US