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 vote161 views2 answers
Mysql add days to date
SQL
0 vote160 views1 answer
Sort by
SQL
0 vote142 views1 answer
Mysql zerofill
SQL
0 vote135 views1 answer
How to fix mysql stop unexpectedly
SQL
0 vote142 views1 answer
Mysql date equals to current_date plus days
SQL
0 vote142 views1 answer
Mysql select inside sum
SQL
7 votes149 views2 answers
N highest salary in sql
SQL
1 vote194 views1 answer
Oracle transaction rollback not working
SQL
8 votes127 views1 answer
How to remove tables from postgresql
SQL
1 vote135 views1 answer
Psql autocomplete for mac brew install
SQL