Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Find the first record, for every day
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