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
2 
DELETE FROM  content
where _type=“PageHistory” and pageId=“91001fac-d646-4c42-9011-c558c89c855e” 
ORDER BY createdAt DESC OFFSET 10;
1 Like
3

getting the following error which using the DELETE statement

{
“code”: 3000,
“msg”: “syntax error - at ORDER”,
“query_from_user”: “delete FROM content\r\nwhere _type="PageHistory" and pageId="91001fac-d646-4c42-9011-c558c89c855e" \r\nORDER BY createdAt desc offset 10 ;”
}

4 
DELETE FROM  content USE KEYS (SELECT RAW META().id FROM content 
where _type=“PageHistory” and pageId=“91001fac-d646-4c42-9011-c558c89c855e” 
ORDER BY createdAt DESC OFFSET 10);