Re: Confused in using ROWNUM in SQL query
From: Brian Tkatch <SPAMBLOCK.Maxwell_Smart_at_ThePentagon.com.SPAMBLOCK>
Date: Thu, 07 Dec 2000 21:24:55 GMT
Message-ID: <3a2fffc2.1457291859_at_news.alt.net>
Date: Thu, 07 Dec 2000 21:24:55 GMT
Message-ID: <3a2fffc2.1457291859_at_news.alt.net>
>But i believe there is something wrong, for example:
>since we are using three tables, which table's rownum is it referring to in where clause?
The way I understand it, Rownum is not reffering to a row in table, that's what ROWID does. Rownum is a counter for output data. Therefore, no matter how the data came to be, it is only the output that matters.
Brian Received on Thu Dec 07 2000 - 22:24:55 CET