SQL Delete Command

Use : This command is used to delete rows or records in a table. 

Syntax :

delete from "tablename"
where columnname OPERATOR value [and|or 
columnnamex OPERATOR valuex]; 

Without the where clause, all records in the table will be deleted.

Example :

delete from  student
where name = 'Puneet' and rollno = 13;

copyright @2008 Punuptech.com