Re: Selecting every other code.... why wont THIS work?

From: Ed Prochak <edprochak_at_adelphia.net>
Date: Thu, 06 Feb 2003 05:52:03 GMT
Message-ID: <3E41FB7B.3080003@adelphia.net>

Niall Litchfield wrote:
> "elziko" <elziko_at_NOTSPAMMINGyahoo.co.uk> wrote in message
> news:3e3e43f6$0$12354$afc38c87_at_news.easynet.co.uk...
>

>>and so on. So by my reckoning, in order to select only every OTHER row in
>>this table I should be able to do:
>>

[]
>
> You should be aware that select .... from testdata doesn't return an ordered
> set of records, so the concept of every second record is pretty much
> meaningless without an order by in the inner select.

Every time I see one of these rownum questions, I feel like screaming.

<rant>

Do these people think ORACLE is a file system or something?

I just don't get it.

what does "every other row of a relational table" mean? NOTHING.

elziko, please try to learn the basic concepts. </rant>

I feel better now. Time for bed.

-- 
Ed Prochak
running: http://www.faqs.org/faqs/running-faq/
family:  http://web.magicinterface.com/~collins
--
"Two roads diverged in a wood and I
I took the one less travelled by
and that has made all the difference."
robert frost

Received on Wed Feb 05 2003 - 23:52:03 CST