2
Reply

Delete Query in SqlServer?

Jitendra Patel

Jitendra Patel

May 7 2011 2:07 AM
1.5k
Hello Experts,

I have one query in sql server 2008.

I have create one table in this table there are not any Primary Key.

my table structure like this.

ID Name
-----------
1  Test1
2  Test2
3  Test3
4  Test4
1  Test1
2  Test2
3  Test3
4  Test4

first time I have add id no 1,2,3,4 this record and second time I have add another 1,2,3,4 Records.

I have delete last 4 records but id is same.

it is possible in single Query?


Answers (2)