Re: Filtered Query on nth row

Hola.

This is one solution:

select column_a, column_b
  from your_table a
 where a.rowid in (select decode(mod(rownum,5),1,b.rowid,NULL)

                     from your_table b)

I would place further WHERE-Conditions in the SUB-Select.

Greez,
Angelo.

-- 


-----------------------------------------------------------------

Angelo Cavallaro     /  /  /   \     TECTUM Beratungsgesellschaft
ORACLE-SW-Berater   /  /  /     \    für Informationsverarbeitung
ancavall.NOSPAM    /  /  /-------\   Tel: 0711/99073-10
@aol.com          /__/__/_________\  Fax: 0711/99073-99



-----------------------------------------------------------------

	 Visit the Home of the Green Ribbon Campaign:

		http://www.ponce.oisoft.com/



-----------------------------------------------------------------