The first n rows or specified rows of the SQLite database are deleted.

N rows before SQLite database Deletion

 

1. Are there any SQL statements that can delete the first n rows of data in the database? (Use C for SQLite)
Assume that the database has a num field, which is an integer and is in ascending order.

If you want to delete the first eight rows of data
Delete from table where num in (select num from Table limit 8)

Ii. How does sqlite3 Delete specified row data? (To Delete the fifth row of data in a data table)

Delete from table where id = (select ID from Table limit 4, 1)