Sorry... trying to get a lot of info out without a lot of text...
lkup_info is populated when data is loaded, and data is loaded
daily... so MAX(date) would work fine with sub selects, which
don't exist... though I have an auto increment field as well.
I guess I will just have to keep a s
Sounds like you have a table (lkup_info) of load dates (date), in which you
record fileid (did) and date. Sounds like you do not have a separate table
of fileids. I'm assuming that the lkup_info table is updated synchronously
with the loading of each file that the table is recording, though y
MySQL 3.23.41 on Solaris
Is it possible to select only the latest entries
from a table?
For instance I have a table of datasets that get
loaded each day. I want to find the latest date that
each dataset was loaded.
I thought maybe a join against itself might be the
answer, but this does
