An example, which use a subquery (available from MySQL 4.1):
select eqid, paramid, lastmodified, value from eq_deltalist param1
where lastmodified = (SELECT max(lastmodified) FROM eq_deltalist
WHERE paramid = param1.paramid AND eqid = param1.eqid AND
lastmodified <= now())
You would probably wa
I'd like to setup an application to store equipment configuration data in a
MySql database. The basic setup is that each equipment has a certain number
of parameters which may change over time. I'd like to track these changes
over time and want to be able to create queries which determine the statu
