大家来找茬...
有两个sql语句，我写的是一样的，可是为什么执行出来的结果不一样啊，找得好晕啊
select top 5 a.Action_ID,a.[User_ID], a.Total_Score ,b.Action_Desp, b.CreateTime , b.Point_Change
from tbl_Action_Hist b inner join tbl_Record_Score a on a.Action_ID=b.Action_ID where
a.Action_ID not in (select top (5 * (1 -1)) a.Action_ID from tbl_Action_Hist b )
and b.Student_ID='100003' and b.Point_Change like '-%'
and b.CreateTime between '2013-4-11' and '2014-4-15'
select top 5 a.Action_ID,a.[User_ID], a.Total_Score,b.Action_Desp,b.CreateTime , b.Point_Change
from tbl_Action_Hist b inner join tbl_Record_Score a on a.Action_ID=b.Action_ID where
a.Action_ID not in (select top(5 * (1 -1)) a.Action_ID from tbl_Action_Hist b )
and b.Student_ID='100003' and b.Point_Change like '-%'
and b.CreateTime between '2013-4-11' and '2013-4-15'
