asp中SQL语句的问题!菜鸟问题!请高手帮忙解决

2025-04-26 14:08:12
推荐回答(2个)
回答1:

select top 10 * from news where BigClassName = 'AAAAA' or BigClassName='BBBBB' or BigClassName='CCCCC' order by id desc
只要是AAAAA或者BBBBB或者CCCCC里面的内容都能抓到!

回答2:

select top 10 * from news where BigClassName='AAAAA' and BigClassName='BBBBB' and BigClassName='CCCCC' order by id desc"