我使用(“从TBL_OIP2选择*")查询来选择记录，它显示了所有记录，当我使用(“从TBL_OIP2选择*，其中rownum> 101和rownum< 200")时，则显示为空. .. [英] i pick the records using ("Select * from TBL_OIP2") query and it shows the all records and when i use ("Select * from TBL_OIP2 where rownum>101 and rownum<200 ") then it shows me the empty...

问题描述

我使用

("Select * from TBL_OIP2")

查询，它会显示所有记录，并且在我使用

query and it shows the all records and when i use

("Select * from TBL_OIP2 where rownum>101 and rownum<200 ")

，然后向我显示空表.所以请告诉我问题出在哪里?

预先谢谢您.

then it shows me the empty table. so plz tell me where is the problem?

Thank You in advance.

推荐答案

请看以下网页.您可以在这里找到原因和解决方案:
http://blog.lishman.com/2008/03/rownum.html [ ^ ]

祝你好运！

Have a look at the following webpage. Yoou can find the reason and solution there:
http://blog.lishman.com/2008/03/rownum.html[^]

Good luck!

select S.field1,S.field2 from  (select field1,field2 from table where field1>26 and field1<30  )  S  where S.field1<=27 order by S.field1 asc

* means  group  of  values in your  tables.so inline subquery are not handled it .so  wanted  field only  implemented in inline sun query and  assigned

我已经确定了这个问题，如果您从您的表中显示数据样本集，那么我可以说得更清楚

i had identified The problem if u display sample set of data from ur table then i can say u more clearly

这篇关于我使用(“从TBL_OIP2选择*")查询来选择记录，它显示了所有记录，当我使用(“从TBL_OIP2选择*，其中rownum> 101和rownum< 200")时，则显示为空. ..的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！