How can you get the alternate records from the table in the SQL?

This could be done by putting the ROWNUMBER into your SELECT statement. As a clue consider:
WHERE RowNumber % 2 = 0 --Even
WHERE RowNumber % 2 = 1 --Odd