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 vote150 views2 answers
Oracle chain rules
SQL
0 vote269 views1 answer
Android sqlite add column if not exists
SQL
8 votes171 views1 answer
Oracle tablespace datafile max size
SQL
2 votes157 views1 answer
How to show the whole table in sql
SQL
16 votes145 views1 answer
Sqlserver add column to table
SQL
0 vote198 views1 answer
Varchar2 length in oracle
SQL
1 vote147 views1 answer
Mariadb alter user host
SQL
0 vote295 views1 answer
The differnece between to values in sql
SQL
5 votes159 views2 answers
Create function postgresql
SQL
0 vote140 views1 answer
Sql comparison operators
SQL