Question

ASP怎么调用后台新闻列表，我是菜鸟，求助大家，谢谢

"select top 6 * from news order by id desc"
所有新闻都显示出来了。后台里面有两个分类公司新闻和行业新闻 ID分别是10和27。我想分别显示。怎么弄？

Answer 1

select top 6 * from news where [ID] = 10 order by id desc
select top 6 * from news where [ID] = 27 order by id desc