On 3/14/07, abang sunda <[EMAIL PROTECTED]> wrote: > > > > > > > all, > > mo tanya kenapa query > > select column1, rownum from table ; > mempunyai hasil > > tetapi > select column1, rownum from table WHERE ROWNUM > 1; > > selalu now rows selected ?
no rows selected maksudnya.. ini penjelasannya.. ROWNUM is what is referred to as a pseudo-column. It is not data in the database or table and has absolutely no relationship to anything in the database, data file, tablespace, or table or to the order in which a row is inserted into a table. Rather it is the number of a row selected from a table and depending on the order in which rows are selected will change. Because the first row selected is ROWNUM 1, the second ROWNUM 2, trying to view row 2 with a simple use of ROWNUM will not work. -- chiank
