| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: Problem with rownum
Both results look accurate..?
rownum is a pseudo column and only refers to a count of rows returned
by the query.
Do a query on the newsgroup - there are many answers regarding how to
use and how to not use this pseudo column. I wonder if you are trying
to do the following;
Select min(nummer) from Artikel
where Number > 60000;
Received on Tue Jan 11 2005 - 09:13:59 CST
 |
 |