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

4 votes194 views2 answers
Postgres update single column
SQL
0 vote200 views1 answer
Get schema of table sql
SQL
1 vote194 views1 answer
Sql server: difference between hashtable and table declared using declare keyword
SQL
3 votes201 views1 answer
Oracle transaction commit rollback example
SQL
4 votes191 views1 answer
List tables sqlite
SQL
1 vote199 views1 answer
Check if mysql is installed
SQL
0 vote208 views1 answer
Offset in postgresql example
SQL
0 vote191 views1 answer
Dump multiple tables mysql
SQL
4 votes196 views1 answer
Find tables with column name in sql
SQL
10 votes205 views2 answers
SQL rounding numbers
SQL