SQL Query to Delete data from Database byAdmin •August 19, 2016 The DELETE statement allows rows to be deleted from named table by using following Command DELETE FROM tableName WHERE [searchcondition] exact syntax: Delete from staff where staf_id=12;