This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

Bot to delete all records except the most recent 10 records

Posted on 10-24-2023 07:40 AM
StephenSaid
Silver 1
Silver 1
Reply posted on --/--/---- --:-- AM

I need a bot to delete all the records in the table except for the last 10 records.

I guess I need a query in the condition below using TOP and ORDER. 

StephenSaid_1-1698158174599.png

StephenSaid_0-1698158124680.png

How can I achieve this, please?

 

0 6 401
Topic Labels
0 Likes
6 REPLIES 6
Top Labels in this Space