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

Home -> Community -> Usenet -> c.d.o.tools -> Retrieving first occurrence - How?

Retrieving first occurrence - How?

From: GF <GAYLEN.FRALEY_at_MAIL.SPRINT.COM>
Date: Wed, 16 Aug 2000 13:35:34 GMT
Message-ID: <8ne5b4$mim$1@nnrp1.deja.com> 






Assume that table A has multiple records for a given id.  Is there a
way to select only one (or the first) occurrence  of each id?  There is
no other field to group by/having.  I just always want the last record
that was added.  There is no timestamp field.



Thanks!



gaylen.fraley_at_mail.sprint.com




Sent via Deja.com http://www.deja.com/


Before you buy.
Received on Wed Aug 16 2000 - 08:35:34 CDT












Original text of this message













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