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