SQOOP Question

select * form ( select *.RowNumber() over (order by first,last) as RowNumber from table_name ) as r where r.RowNumber % =0
select * form ( select *.RowNumber() over (order by first,last) as RowNumber from table_name ) as r where r.RowNumber % =1