Select odd records sql

SELECT t.First, t.Last
FROM (
    SELECT *, Row_Number() OVER(ORDER BY First, Last) AS RowNumber 
            --Row_Number() starts with 1
    FROM Table1
) t
WHERE t.RowNumber % 2 = 0 --Even
--WHERE t.RowNumber % 2 = 1 --Odd

Source: stackoverflow.com

Similar codes

0 vote261 views2 answers
Sql update multiple tables
SQL
1 vote289 views1 answer
Increase existing date in sql
SQL
32 votes285 views6 answers
How to change column name in sql
SQL
0 vote262 views1 answer
Count number of entires by months sql
SQL
1 vote401 views3 answers
Uninstall postgresql mac
SQL
-1 vote278 views2 answers
Create temporary table sql
SQL
0 vote264 views1 answer
Sql server alter table add column datetime default current_timestamp
SQL
17 votes327 views4 answers
Show all tables in oracle
SQL
1 vote269 views1 answer
Sql server epoch to datetime
SQL
1 vote287 views1 answer
Altrer name column postgres
SQL