kenapa gak pake limit aja !!! On 13 Mar 2007 23:53:23 -0700, chiank <[EMAIL PROTECTED]> wrote: > > On 3/14/07, abang sunda <[EMAIL PROTECTED] <abang_sunda%40yahoo.com>> > 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 > >
[Non-text portions of this message have been removed]
