Sunday, December 5, 2010

Delete statement

DELETE statement is used to remove rows from the table.


Syntax:
delete from <table_name> [where clause]

e.g.
SQL>delete from employees where employee_id = 902;


CAUTION: Delete without 'Where' clause will remove all rows from table.


Have a question or comment? Post it below!


0 Comments:

Post a Comment