Re: Filtered Query on nth row

From: <ahmetco_at_kocsistem.com.tr>
Date: 1998/02/10
Message-ID: <887116134.2010316804@dejanews.com>#1/1

I don't know such a key like 'ROWCNT' . I think You mean ROWNUM. But there is a problem , ROWNUM doesn't work true ( that we want to work like ) when used with order by and also MOD(ROWNUM,N)=X doesn't work . If you explain it I'l happy.

by..

In article <19980210015201.UAA15698_at_ladder02.news.aol.com>, winxxniw_at_aol.com (Winxxniw) wrote:
>
> Actually, I don't think you even need to do PL/SQL. Just try...
>
> select * from table where (ROWCNT mod N) = 0
>
> (I'm not sure if that's the correct operator for mod, but I think you see the
> approach!)
>
> Good luck!
>
> winxxniw_at_aol.com

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet

Received on Tue Feb 10 1998 - 00:00:00 CST