SQL语句是这样的:SELECT TOP 15 D.*,M.City AS Area
from dep D left join mep M ON M.ID = D.MemberID
where D.Status = 8 and D.type like '001449%' and (D.id<(select min(id) from
(select top 30 id from dep order by id desc) as T )) order by D.ID desc我改变下面的top 30 为top 15或top 45等查询的结果是一样的,不知道为什么,请教各位!谢谢!
from dep D left join mep M ON M.ID = D.MemberID
where D.Status = 8 and D.type like '001449%' and (D.id<(select min(id) from
(select top 30 id from dep order by id desc) as T )) order by D.ID desc我改变下面的top 30 为top 15或top 45等查询的结果是一样的,不知道为什么,请教各位!谢谢!
select top 30 id from dep order by id desc这里用的是倒序,top30改变以后,
此条件 D.id<(select min(id) from
(select top 30 id from dep order by id desc) as T ) 的结果也变了。
所以结果不一样。
from dep D left join mep M ON M.ID = D.MemberID
where D.Status = 8 and D.type like '001449%' and (D.id<(select min(id) from
(select top 30 id from dep order by id desc) as T )) order by D.ID desc主select和子select需要有相同的查询条件