[thelist] SQL - searching a history table
Matt Warden
mwarden at gmail.com
Tue Oct 10 15:49:00 CDT 2006
thelist,
Suppose the following table structure:
WIDGET
----------------------------
id
status
WIDGET_STATUS
----------------------------
widgetid
status
date_updated
In english, I need the number of widgets with a widget status record
for status 'X' and date_updated within the range 01-MAY-2006 and
01-JUN-2006. The catch is that this must be the last update to the
status in that time period.
Any ideas? I have something close now, but I will refrain from
describing it to avoid boxing in creativity.
--
Matt Warden
Cleveland, OH, USA
http://mattwarden.com
This email proudly and graciously contributes to entropy.
More information about the thelist
mailing list