One table contains history. The old history is never replaced. New history is added. What is relevant is the most recent history. Is there a way to find the newest records without the KeyID?
On Fri, Dec 13, 2019 at 8:58 AM Mark Rotteveel [email protected] [firebird-support] <[email protected]> wrote: > > > On 2019-12-13 12:48, Clyde Eisenbeis [email protected] [firebird-support] > wrote: > > I added the KeyID so I could sort from newest to oldest. Was it > > necessary to add this KeyID, or is there another way to find the > > newest records without the KeyID? > > That depends on what you're trying to achieve, what data you have and > what results you want. > > Mark > >
