 |
 |
Archives of the TeradataForum
Message Posted: Wed, 23 Jun 2004 @ 16:43:34 GMT
| Subj: | | Re: How to select row numbers with something like rownum |
| |
| From: | | Victor Sokovin |
| | It was a great solution, but incase I want to use this in my WHERE condition how do I do that. | |
A derived table might help:
select * from
(select row_number() over (order by col1) AAA, col2
from some_table ) DT
where AAA < 11 ;
It might make sense to make the DT as small as possible by putting all the restrictions in its definition.
Regards,
Victor
| |
