Sometimes we are required to delete the data from the table. We use the following statement for the same.

Delete from Tablename where field2 = value2

Example :
Delete all from Addressbook where Addresss2 = "Gr.Floor, ABC Apartments"

The above statement will delete The record having value of the field Address2 as "Gr.Floor, ABC Apartments"

All the records having the above value in the table will be deleted.

These are basic operations of the tables that keep the records inside the database.
For further simple operations of the table please see page http://www.freeecommersetips.com/Software_tips_sql_part_2.asp