Access多条件查询前几条数据 

select top 5 *  FROM  News  where  NewsTypeID=3 and (NewsIsRecommend=true and NewsIsInvisible=false)  order by NewsTime desc

换成

select *  FROM (select top 5 * from News where NewsTypeID=3 and (NewsIsRecommend=true and NewsIsInvisible=false))   order by NewsTime desc

 

 

posted @ 2012-06-05 13:48  Setme  阅读(2982)  评论(0)  编辑  收藏  举报