How to delete the last record in a table?

Question

Python

Hello. What is wrong? I want to delete the last record in the Customer table and the Delivery table

cur.execute('DELETE FROM Клиент ORDER BY Код_клиента DESC LIMIT 1')
        cur.execute('DELETE FROM Доставка ORDER BY Код_доставки DESC LIMIT 1')
        con.commit() #сохранить изменения

Option 1 worked:

cur.execute('SELECT Код_доставки FROM Доставка ORDER BY Код_доставки DESC LIMIT 1')
        show = cur.fetchone()
        print(show[0])
        cur.execute(f'DELETE FROM Доставка WHERE Код_доставки = {show[0]}')
        con.commit() #сохранить изменения

Answer 1

First, the delete statement does not accept order by clauses. Secondly, SQLite, like many other DBMS, stores data in an arbitrary order, and therefore the concept of "last record" does not make sense. You need to make a selection sorted by the field that determines the order of the records, get the ID of the first or last record in the selection and pass it to the WHERE clause of the delete query.