| Subject | Re: [firebird-support] How do I limit an SQL search list to 10 records? |
|---|---|
| Author | Clyde Eisenbeis |
| Post date | 2019-12-13T15:48:04Z |
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 mark@... [firebird-support] <firebird-support@yahoogroups.com> wrote:On 2019-12-13 12:48, Clyde Eisenbeis cte677@... [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