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.
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.
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.
Shivamkumar said:
1 decade ago
Delete from tablename where column name;.
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.
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!
Rakesh dasari said:
1 decade ago
Update used only to make changes in existing records, reamainin options are used to do operations on the table not individual columns.
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.
Rinkesg said:
1 decade ago
Ramya is right.
Raku said:
1 decade ago
Manche is right.
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>;
Post your comments here:
Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers