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 -> SQL QUESTION

SQL QUESTION

From: ggstr <gguerillot_at_freesurf.fr>
Date: Mon, 18 Sep 2000 20:21:06 +0200
Message-ID: <8q5m79$2dfp$1@spartacus.freesurf.fr> 






i have a table with 3 fields : OBJECT,DATE,VALUE
every object can have many values with different date



i want to display only the last value for each object(date most recently)
like this: object,date,value



what is the good sql code to to this?




thanks for help!
Received on Mon Sep 18 2000 - 13:21:06 CDT












Original text of this message













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