Re: Deleting with SQL

[Charles Wilt <charles.wilt@xxxxxxxxx>]

So for every program, you'll end up with...
either
- >= 30 entries, starting at 2/15/2015
- <= 30 entries, going back as far as needed?  (assuming it's possible that
you don't have 30 entries currently logged)



Charles

On Mon, Apr 20, 2015 at 7:38 AM, John R. Smith, Jr. <
smith5646midrange@xxxxxxxxx> wrote:

> I have a file that is a log of who ran programs on what date that I need to
> purge but the purge has dual criteria.  I need to purge based on keeping x
> number of entries and entries before x date.  For example, I need to keep
> all entries after 02/15/2015 AND also the last 30 entries.  So, if an entry
> falls inside of either of these criteria, I keep it.  The user is
> immaterial
> to the result set.
>
>
>
> I'm not sure I have explained that very well but in the event that I have,
> can anyone tell me how to do it through SQL?
>
>
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.