Delete from table with limit (first X rows excluded)

3.6.2014 • 29.8.2015 (aktualizováno)

MySql

delete from table with limit.sql Raw #

DELETE FROM table
WHERE ID IN
        (
        SELECT ID
        FROM
            (
                SELECT ID
                FROM table
                WHERE Type = 'TEST'
                ORDER BY ID
                LIMIT 30,60
            ) a
        )