摘要: 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-- 阅读全文
posted @ 2011-11-13 16:20 小锋神 阅读(8612) 评论(0) 推荐(1) 编辑