Table: the name of the deleted data Table.
1: The table must be a fact-existing table. The table must be a table that actually exists in the database. It must be an intermediate table created by a select statement.
2: This method allows you to join data that meets certain association conditions in two tables at the same time.
Top (*) is used to specify the number of data to be deleted.
1: Top (N) indicates to delete the Top N data entries in the table.
2: it cannot be used together with order in delete, so it cannot be connected through top or order by to delete all the first few records sorted by a certain condition.
3: The modified statement cannot be used in sql2000.
Search_condition is used to specify conditions for data deletion.
1: This command is the same as search_condition in select.
2: This command will delete all data queried through the query conditions. (In the case of no top ).