Re: Record count issue

Yeah, I'm really thinking there was some function or whatnot that would
number each row returned.

It's not RID or RRN.

(Lots of research later...)

Try this:

select row_number() over(order by rrn(a)),
rrn(a), rid(a), a.*
from rob.darryl a
ROW_NUMBER RRN ( A ) RID ( A ) MYCOL
1 1 1 D
2 2 2 D
3 4 4 F
4 5 5 G

So you can do stuff like

With T1 as (
select row_number() over(order by rrn(a)) as rowN, a.*
from rob.darryl a )
select t1.*
from t1
where rowN between 1 and 3
ROWN MYCOL
1 D
2 D
3 F



Rob Berendt