摘要：
select [id],[poster],[fid],[title],[editername],[modifytime] from(select [id],[poster],[fid],[title],[editername],[modifytime], row_number() over( order by id desc) as row from [news] WITH (NOLOCK)where path like 'A_B%' and id not in(select id from [news] where layer=7 or layer=5)) a where r 阅读全文
posted @ 2011-04-07 09:29 nasdaqhe 阅读(284) 评论(0) 推荐(0) 编辑