DML statement-Delete

nDelete statement is used to remove rows from a table, depending on how many rows satisfy the search condition you specified in where clause

Syntax:

üDELETE FROM table_name
WHERE some_column=some_value

üDELETE * FROM table_name

Query:

üDELETE FROM EMPtbl1 WHERE EMpname=‘Batista' AND company=‘IBM'

üDELETE * FROM EMPtbl1