Re: ROWNUM comparisons using < vs >

Alright, so now you know why you can't do it... there is a way to do it:
create a view with your desired conditions (except rownum) and your desired output columns plus rownum renamed to rowcount. now select from the view with the desired > condition on rowcount.

This is also how you can select N of M conditions.

Ray Received on Thu Jan 21 1999 - 23:41:48 CST