请问在SQL中,如何删除连续的一段记录?非常感谢(100分)

M

mezhuge

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2008-07-01

• #1

[]

 

L

lngdtommy

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2008-07-02

• #2

delete from tablename<br>where id &gt; value1 and id &lt; value2

 

C

Corn3

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2008-07-02

• #3

delete from Table1 where id between Value1 and Value2

 

M

mezhuge

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2008-07-02

• #4

多人接受答案了。