Help with select statement
From: Dan Gibbons <Daniel.Gibbons_at_SEB.co.uk>
Date: Tue, 30 Jan 2001 15:35:17 -0000
Message-ID: <1aBd6.33$u7.98_at_nntpserver.swip.net>
Date: Tue, 30 Jan 2001 15:35:17 -0000
Message-ID: <1aBd6.33$u7.98_at_nntpserver.swip.net>
Hi,
[Quoted] I need some help with the following table please:
CODE UPDATE_DATE CLOSE_PRICE 1749 2001-01-29 19:31:36 1.175 1749 2001-01-26 19:31:30 1.175 1749 2001-01-25 19:31:33 1.195 1749 2001-01-24 19:31:37 1.175 1748 2001-01-23 19:31:42 1.11 1748 2001-01-22 19:31:37 1.04 1748 2001-01-19 19:20:58 1.035
In Oracle is there any way to select one record for the latest UPDATE_DATE so I can get something like
CODE UPDATE_DATE CLOSE_PRICE 1749 2001-01-29 19:31:36 1.175 1748 2001-01-23 19:31:42 1.11
Basically for each CODE I need to get the latest CLOSE_PRICE.
Thanks in advance
Dan Received on Tue Jan 30 2001 - 16:35:17 CET