请帮忙看下为什么下列两个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 <= 180Select * 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
(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 <= 180Select * 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
Select distinct ResourcesGuid From BizResources_Base
如果其确实是唯一的,就不知道原因了。
我试了下你的SQL,OK呀,161~180 181~200