SQL 随即数不能实现为什么？

Question

UPDATE BaseUser SET G_ID = 10 WHERE G_ID =0 AND is_manager = 1
AND ID IN(select top 3 ID from BaseUser order by newid())

 

我执行这条语句， 为什么不能随即的更新三条数据， 而只是随机更新一条，两条，或者不更新？

Answer 1

UPDATE BaseUser SET G_ID = 10 WHERE ID IN(select top 3 ID from BaseUser where  G_ID =0 AND is_manager = 1 order by newid())

Answer 2

WHERE G_ID =0 AND is_manager = 1AND ID IN(select top 3 ID from BaseUser order by newid())3个and的条件，应该是随机的有几条符合，但是肯定是不大于3条的