how to delete multiple row in SQl
how to delete multiple row in Sql
Loading
7 Replies
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Hi Technical guru,
You can multiple row in many way. like followings: Suppose you've a table like following;
- CREATE TABLE tblEmploye
- (
- EmpId INT IDENTITY(1,1) PRIMARY KEY,
- Name VARCHAR(50) NOT NULL,
- Age INT NOT NULL,
- DepartmentName VARCHAR(50)
- )
- GO
1. To delete all data from a tablee.
- DELETE FROM tblEmployee
- DELETE FROM tblEmployee
- WHERE DepartmentName='HR'
- DELETE FROM dbo.tblEmploye
- WHERE Age>30
Happy Coding.........
Code AlonePosted Oct 4, 2018, 3:53 AM