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 -> DISTINCT ON ONE ROW

DISTINCT ON ONE ROW

From: Joerg Leute <leute_at_itdesign.de>
Date: Thu, 29 Jul 1999 15:37:15 +0200
Message-ID: <7npld9$mr9$1@news.lf.net> 





Hi everybody



Suppose i have a table like this


ID        Name
1            Joe
2            Frank
3            Frank
4            Frank
5            Jack





Is there any way (like distinct) to have a result like this


ID        Name
1         Joe
2         Frank
5         Jack






Many Thanks in advance



Joerg


Received on Thu Jul 29 1999 - 08:37:15 CDT












Original text of this message













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