To create query that returns every other record, use the MOD function of 2 applied to the relative record number to return a 1 for odd numbers and 0 for even numbers.

Setting a condition of  MOD( RRN( Your_Table ), 2 ) = 0   will return only even numbered records

 

Ref#: 1480519

 

 

 

 


Still have questions? We can help. Submit a case to Technical Support.

Last Modified On: April 21, 2017