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

 

【推广】 免费学中医，健康全家人
原文地址：https://www.cnblogs.com/Setme/p/2536575.html