asp循环去除重复

sql="select

*

from

dowlond_biao

where

classname

like

'"&ampsearchname&"'"

改成

sql="select

distinct

*

from

dowlond_biao

where

classname

like

'"&searchname&"'"

for

cur

(select

s.id,s.name,s.num,count(1),max(rowid)

max_rowid

from

student

s

group

by

s.id,s.name,s.num

having

count(1)>1)

loop

delete

from

student

where

rowid<>cur.max_rowid

and

id=cur.id

and

name=cur.name

and

num=cur.num

end

loop

for cur (select s.id,s.name,s.num,count(1),max(rowid) max_rowid from student s group by s.id,s.name,s.num having count(1)>1)

loop

delete from student where rowid<>cur.max_rowid and id=cur.id and name=cur.name and num=cur.num

end loop

---