What is the Delete Statements in SQL?

Ads
 

What is the Delete Statements in SQL?

What is the Delete Statements in SQL?

View Answers

November 19, 2010 at 3:58 PM

Hi,

Here is the answer,

Delete statement in SQL is used to delete partial/all data. Especially delete statement is useful in case of partial delete depending upon our criterias otherwise use TRUNCATE to

delete whole data from table.

DELETE FROM table_name WHERE column_name = some_value

Delete All Rows:

DELETE FROM table_name or DELETE * FROM table_name

Thanks,

Ads









Related Tutorials/Questions & Answers:
What is the Delete Statements in SQL?
What does the delete operator do?
Advertisements
What does the delete operator do?
What is difference between TRUNCATE & DELETE
SQLl query count and group by
JDBC: Delete Record using Prepared Statement
DELETE
Understanding Common SQL statements
delete
predicates and statements?
delete retailer jsp file (sir..is this a good logic.. jsp file is useful for what purpose)
Jdbc statements
java statements
Java statements
Java statements
Jdbc statements
Java statements
Java Control Statements
Delete Account
Hibernate generated SQL statements on console
DECESION MAKING STATEMENTS
The INSERT INTO Statements in SQL?
java program using control statements...
Difference between TRUNCATE and DELETE commands
To delete post
Objective C if else statements syntax
general syntax for a SELECT statements
Hibernate delete example program
Avoiding â??!= nullâ?? statements in Java?
delete jsp
JPA delete query - EJB

Ads