Click here to Skip to main content
11,504,689 members (69,528 online)
Rate this: bad
good
Please Sign up or sign in to vote.
See more: Oracle
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 table. so plz tell me where is the problem?

Thank You in advance.
Posted 19-Jul-12 22:25pm
Edited 20-Jul-12 0:24am
v2
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

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!
  Permalink  
Comments
ssd_coolguy at 20-Jul-12 5:02am
   
my 5! nice blog..
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 2

      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 
  Permalink  
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 3

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

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 F-ES Sitecore 285
1 CHill60 245
2 Sergey Alexandrovich Kryukov 213
3 OriginalGriff 185
4 Richard Deeming 180
0 Sergey Alexandrovich Kryukov 723
1 Peter Leow 490
2 Maciej Los 475
3 DamithSL 470
4 OriginalGriff 437


Advertise | Privacy | Mobile
Web04 | 2.8.150520.1 | Last Updated 20 Jul 2012
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100