Toad World® Forums

Export just certain rows?

where rownum

where rownum

between 1 and 50

Where rownum in (1,2,3, … ,48,49,50)

Don’t ya just love applied logic:

Where !(rownum
OR rownum > 50)

Roger S.

This communication, including any attached documentation, is intended only for the person or entity to which it is addressed, and may contain confidential, personal and/or privileged information. Any unauthorized disclosure, copying, or taking action on the contents is strictly prohibited. If you have received this message in error, please contact us immediately so we may correct our records. Please then delete or destroy the original transmission and any subsequent reply.

Yes – your solution is essentially DE Morgan’s theorem applied to
the BETWEEN example code’s actual underlying logic (i.e. rownum >= 1
and rownum

And who said all those logic and implied math classes would not be useful in
real life J