sql中not in后面跟条件用什么连接

来源：百度知道 编辑：UC知道 时间：2024/06/18 07:26:57
select top 24 * from movieinfo where [MID] NOT IN (select top 6 MID from movieinfo where MIndex=1 and MTypeID between 10 and 13 ) and MIndex=1 and MTypeID between 10 and 13

我这样写后什么都差不出来，哪位大哥帮帮忙啊！

select top 24 * from movieinfo where [MID] NOT IN (select top 6 MID from movieinfo where MIndex=1 and MTypeID between 10 and 13 )

你这里查出的元组是不满足 MIndex=1 and MTypeID between 10 and 13 的那些

而你后面又查询满足and MIndex=1 and MTypeID between 10 and 13
当然就没有符合要求的元组了

not in 后面是可以加其它条件的
不妨你试试

除了一楼所说的问题外~似乎这句会报语法错误：
select top 24 * from movieinfo where [MID] NOT IN (select top 6 MID from movieinfo where MIndex=1 and MTypeID between 10 and 13 )and MIndex=1 and MTypeID between 10 and 13
你括号里面的top会报语法错误：Incorrect syntax near the keyword 'top'.
去掉括号里的top查一下返回结果集为空，表示没有符合要求的元组