摘要:
select top 12 id,url,titleorname from t_userscolumn A where mark='1' and not exists(select * from t_userscolumn where url=A.url and titleorname =A.titleorname and mark='1' and id>A.id) order by id desc===============================================sql server 2000 中去掉重复值表结构为 zymc-- 阅读全文