Diffetent ways to delete data from tables in SQL

[Jaisudha]

Hi,

I am aware about how to insert, update the records of tables in SQL. But don't know how to delete the records from tables.

Is there any way to delete records on particular condition?
Can we delete all records in the table on single time?

Please provide me the possible queries with proper syntax.

[Modifier]

Hi friend,

SQL is very flexible you can delete the data from table on particular condition or you can also delete all records at same time.

See following syntax:

DELETE FROM Table_Name WHERE field_Name = 'Condition';
//here Table_Name is the name of table on which you want to perform operation.

e.g:

DELETE FROM School WHERE stud_ID = '06';

[Praetor]

It is possible in SQL to delete all the rows from a table using single query statement. All you will need to do is not specify any condition.
For this you will have to use the delete command of the SQL and provide the table name
Here is the query to delete all the rows from the table:

syntax:

delete from table_name;


example:

delete from emp2;

[Katty]

For your kind information you can use another select statement as a condition for the delete command.I have tried this type of queries and it's successful.

see below:

DELETE FROM ACCNT
WHERE
emp_name=( SELECT emp_name FROM ACCNT where dept='IT');