Code:
DELETE from Emplyee
WHERE emp_sal> 3000
As you can see a simple example of the Delete statement , the Delete statement comes first then comes the FROM Clause in which you have to mention the name of the table from which you want to delete the record and then comes the WHERE clause that includes all the conditions that are needed to be satisfied , in the given example the SQL will delete all the records for the employee whose salary exceeds 3000, if you do not mention the WHERE clause then by default all the records will get deleted but the structure of the table will still remain as it is , you will be able to see just the name of the fields without any records.
Bookmarks