ASP如何进行重复数据筛选 sql=\"select distinct A1*from table order by A1 desc
请教：怎样删除asp表格重复数据 最好先备份一下数据表，以免sql有误，造成误删除。SqlServer的sql语句：delete from vtime where cast(id as varchar(10))+'|'+convert(varchar(25)，time，120)not in(select cast(id as varchar(10))+'|'+convert(varchar(25)，maxtime，120)from(select id，max(time)as maxtime from vtime group by id)a)看看是否能达到你的要求。请楼主下次提问题时先说明数据库。access的对应语句如下：delete from vtime where cstr(id)+'|'+cstr(time)not in(select cstr(id)+'|'+cstr(maxtime)from(select id，max(time)as maxtime from vtime group by id)a)
asp access 重复数据调用问题 select pic from[house]group by picselect*from[house]where pic in(select pic from[house]group by pic)
