As part of a db that uses meters (odometer, hourmeter, etc.), I have a table as follows:
MeterReadID - pk
I'm attempting to set up a 'rollover count' that keeps track of any meter rollovers (re-sets to zero) and in order to do so I need a "current meter reading" field. Logic would dictate that the current reading is the last meter read but I need some assistance in wording SQL to set up this field in a query.