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:
ModuleNotFoundError: No module named 'sqlg'
ModuleNotFoundError: No module named 'sqlu'
Advertisements
ModuleNotFoundError: No module named 'sqlx'
ModuleNotFoundError: No module named 'sqlt'
ModuleNotFoundError: No module named 'sqly'
ModuleNotFoundError: No module named 'sqlf'
ModuleNotFoundError: No module named 'sqlf'
SQLl query count and group by
JDBC: Delete Record using Prepared Statement
delete retailer jsp file (sir..is this a good logic.. jsp file is useful for what purpose)
ModuleNotFoundError: No module named 'falcon-sqla'
ModuleNotFoundError: No module named 'falcon-sqla'
ModuleNotFoundError: No module named 'nefertari_sqla'
ModuleNotFoundError: No module named 'pyramid_sqla'
ModuleNotFoundError: No module named 'sqla_declarative'
ModuleNotFoundError: No module named 'sqla-filters'
ModuleNotFoundError: No module named 'sqla_helpers'
ModuleNotFoundError: No module named 'sqla-hierarchy'
ModuleNotFoundError: No module named 'sqla-inspect'
ModuleNotFoundError: No module named 'sqla_declarative'
ModuleNotFoundError: No module named 'sqla-filters'
ModuleNotFoundError: No module named 'sqla_helpers'
ModuleNotFoundError: No module named 'sqla-hierarchy'
ModuleNotFoundError: No module named 'sqla-inspect'
ModuleNotFoundError: No module named 'sqla_mixins'
ModuleNotFoundError: No module named 'sqla-models'
ModuleNotFoundError: No module named 'sqla-paranoid'
ModuleNotFoundError: No module named 'sqla-softdelete'
ModuleNotFoundError: No module named 'sqla-taskq'
ModuleNotFoundError: No module named 'sqla-views'
ModuleNotFoundError: No module named 'sqla-wrapper'

Ads