Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> SQL question
I'm missing something here I know, so give me a nudge.
I've got a table with data that is collected hourly. In other words, there is an ID field several other fields and fianally a date field for when the data was collected. Much like a log file if you will. What I need to do is pull the last timestamp entry for each ID. ID 1 may be in the table 200 times ranging from the first of the month to the last of the month. ID 2 may only be in the table 5 times during the same range. I don't really care, I just need one output for each ID with the data from the last timestamp.
Any thoughts?
-- James Cummings "Chaos, panic, disorder.... my work is done."Received on Sat Jan 11 2003 - 18:11:06 CST
![]() |
![]() |