យើងអាចលុបទិន្នន័យពីក្នុងតារាងផ្សេងៗដោយធ្វើដូចខាងក្រោមនេះ៖
import sqlite3
conn = sqlite3.connect('mydb.db')
cursor = conn.cursor()
cursor.execute('''DELETE FROM EMPLOYEE WHERE AGE > 25''')
cursor.execute('''SELECT * from EMPLOYEE''')
result = cursor.fetchall()
for x in result:
print(x)
conn.commit()
conn.close()
('Vinay', 'KUNG', 20, 'M', 6000.0)
('Sarika', 'VONG', 25, 'M', 8300.0)
('Thirit', 'KANN', 24, 'F', 6000.0)
