Database - Introduction to SQL - Discussion
Discussion Forum : Introduction to SQL - General Questions (Q.No. 2)
2.
The command to remove rows from a table 'CUSTOMER' is:
Discussion:
29 comments Page 2 of 3.
Manche Shekhar said:
1 decade ago
The delete command is used to remove records from a table.
The syntax of delete command is as follow:
Delete from <tablename>;
If u want to remove a particular record then we use where clause.
The syntax of delete command is as follow:
Delete from <tablename> where <condition>;
The syntax of delete command is as follow:
Delete from <tablename>;
If u want to remove a particular record then we use where clause.
The syntax of delete command is as follow:
Delete from <tablename> where <condition>;
Raku said:
1 decade ago
Manche is right.
Rinkesg said:
1 decade ago
Ramya is right.
Kiran Kumar said:
1 decade ago
Both delete and drop are useful for this but with drop we can delete one or total table we can remove where as by using delete with conditions we can delete the rows which are satisfying with that conditions.
K.V.L.K.Prasanna Kumar said:
1 decade ago
We should not use the where clause if we want to delete all the rows and it should end with ; .
Aniley Belayneh said:
1 decade ago
The DELETE statement is used to delete rows in a table.
SQL DELETE Syntax
DELETE FROM table_name
WHERE some_column=some_value
////////////////////////////////////////
Note: Notice the WHERE clause in the DELETE syntax. The WHERE clause specifies which record or records that should be deleted. If you omit the WHERE clause, all records will be deleted!
SQL DELETE Syntax
DELETE FROM table_name
WHERE some_column=some_value
////////////////////////////////////////
Note: Notice the WHERE clause in the DELETE syntax. The WHERE clause specifies which record or records that should be deleted. If you omit the WHERE clause, all records will be deleted!
Kawaljeet said:
1 decade ago
The command DELETE delete the rows from a table and by a condition where clause,you can delete a particular row.
Shivamkumar said:
1 decade ago
Delete from tablename where column name;.
Gouthami.g said:
1 decade ago
Delete is used to delete all rows or particular rows from a table.
Eg:
Sql> delete from table name;
O/p: all rows are deleted.
Eg:
Sql> delete table name where column name = value;
O/p: particular rows are deleted.
Eg:
Sql> delete from table name;
O/p: all rows are deleted.
Eg:
Sql> delete table name where column name = value;
O/p: particular rows are deleted.
Hitendra Dineshbhai Pansuriya said:
1 decade ago
Delete is used for row data hence it will be use and after is to change structure of table like add and drop or column and index.
Post your comments here:
Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers