DELETE statement is used to removes one or more rows in a table
or view.
Syntax:-
Example:-
Following is the table "Employee" where we will apply the delete statement
Id
|
Name
|
Age
|
Address
|
1
|
Alok Kumar Singh
|
30
|
IN
|
2
|
Tomas Paul
|
45
|
NZ
|
3
|
Cristomfer Dee
|
85
|
AU
|
4
|
Niel Macengi
|
55
|
US
|
Delete query
Delete from employee where Id=4
Id
|
Name
|
Age
|
Address
|
1
|
Alok Kumar Singh
|
30
|
IN
|
2
|
Tomas Paul
|
45
|
NZ
|
3
|
Cristomfer Dee
|
85
|
AU
|
We can remove all the rows from the table by below delete query
No comments:
Post a Comment
Note: only a member of this blog may post a comment.