N1QL Delete statements ..which deletes all the records except first 10 record

SQL++
1

I have 100 records.I want to keep first 10 records and delete the rest 90.How to query this delete scenario?
Below is the query to select first 10:

select * from content where _type=“PageHistory” and pageId=“91001fac-d646-4c42-9011-c558c89c855e” order by createdAt desc limit 10

1 Like