Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Help with select statement
Hi,
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 - 09:35:17 CST