在access中,有句SQL语句不知如何写?我用等于是可以的,不等于就出错了!
这一句是正确的
select * from news a where id in (select top 5 id from news where BigClassName='通知通告' and a.smallclassname=smallclassname order by id desc) order by smallclassname,id desc
改成不等于就出错了
select * from news a where id in (select top 5 id from news where BigClassName!='通知通告' and a.smallclassname=smallclassname order by id desc) order by smallclassname,id desc请问如何写?谢谢!
这一句是正确的
select * from news a where id in (select top 5 id from news where BigClassName='通知通告' and a.smallclassname=smallclassname order by id desc) order by smallclassname,id desc
改成不等于就出错了
select * from news a where id in (select top 5 id from news where BigClassName!='通知通告' and a.smallclassname=smallclassname order by id desc) order by smallclassname,id desc请问如何写?谢谢!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货