Home -> Usenet -> comp.databases.oracle -> Newbie : Find newest date

Newbie : Find newest date

From: Jesper Clausen <bodumag_at_dial.eunet.ch>
Date: 1995/11/09
Message-ID: <bodumag.12.000CC4B4_at_dial.eunet.ch>#1/1 






Hello



I have a table which look like this :



Article      Price      Date



a              2.00      11-NOV-93
a              2.50      11-NOV-95
b              1.00      11-DEC-94
b              2.40      06-JUN-95







How do i create a select statement which retrieve the row with the highest 
date ? - what i wan't is  :


a      2.50    11-NOV-95
b      2.40    06-JUN-95 





Please write to 



bodumag_at_dial.eunet



Thanks 



Jesper
Received on Thu Nov 09 1995 - 00:00:00 CET












Original text of this message