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

9 votes378 views6 answers
Oracle substring
SQL
0 vote370 views1 answer
T-sql email validation
SQL
18 votes361 views4 answers
Mysql current date between two dates
SQL
4 votes383 views2 answers
Sqlalchemy_database_uri for mysql
SQL
-1 vote346 views1 answer
Add bool column in sql
SQL
0 vote367 views1 answer
Code to move ietms from one table to another myswl
SQL
4 votes360 views2 answers
Sql offset
SQL
6 votes376 views2 answers
Difference between join vs union
SQL
1 vote351 views1 answer
Create index concurrently postgres
SQL
0 vote370 views1 answer
View to table sql
SQL