How to fetch alternate records from a table?

How to find even and odd numbers in SQL Server
How to fetch alternate records from a table?
How to print odd number in sql server
How to fetch odd rows in sql server
Finding even or odd ID values in Sql Server
write an sql query to show only odd rows from a table.
sql server determine if number is odd or even

SQL Script:
--Even number
select * from [Person].[Person] where BusinessEntityID % 2=0
go
--Odd numbers
select * from [Person].[Person] where BusinessEntityID % 2!=0