Sql delete vs truncate
shape
LIMIT/OFFSET clause (for MySQL) or ROW_NUMBER() function (for SQL Server, PostgreSQL, or Oracle). ROW_NUMBER() function in SQL is a window function that assigns a unique sequential integer to rows within a result set. The numbering starts at 1 for the first row and increments by 1 for each subsequent row in the specified order. It is typically used to assign a rank or row number to rows in a result set based on a particular order.