SQL Table Data Delete

This can be used to delete the table data temporarily.

Syntax:

    Delete <table_name> where <condition>;

Example:

     SQL> DELETE student;

     If you are not specifying any condition this will delete entire table.

     SQL> DELETE Student  WHERE no = 2;