oracle rownum 问题请教

[songxiaolin1831]

请帮忙看下为什么下列两个sql语句的志向结果是一样的

Select * From BizResources_Base a, (Select ResourcesGuid,ROWNUM As OracleRownum From
(Select ResourcesGuid From BizResources_Base Where 1=1 Order By CreateTime asc) Where ROWNUM <= 180) b
Where a.ResourcesGuid=b.ResourcesGuid And b.OracleRownum >= 161 And b.OracleRownum <= 180

Select * From BizResources_Base a, (Select ResourcesGuid,ROWNUM As OracleRownum From (Select ResourcesGuid From BizResources_Base Where 1=1 Order By CreateTime asc)Where ROWNUM <= 200) b Where a.ResourcesGuid=b.ResourcesGuid And b.OracleRownum >= 181 And b.OracleRownum <= 200

[anyoneking]

你的ResourcesGuid是主键吗？或者是唯一属性吗？如果不是的话，是否应该在子查询中加入distinct
Select distinct ResourcesGuid From BizResources_Base
如果其确实是唯一的，就不知道原因了。

[songxiaolin1831]

ResourcesGuid是主键阿

[popeye627]

看看是不是資料問題 或者 是不是关联的时候主key不全
我试了下你的SQL，OK呀，161~180 181~200