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

-1 vote160 views1 answer
Mysql select all columns and specific fields as
SQL
3 votes244 views2 answers
Savepoint in sql
SQL
0 vote144 views1 answer
Mysql show category once count how many products
SQL
1 vote567 views1 answer
How to lock table in mysql
SQL
0 vote146 views3 answers
Get free card roblox
SQL
0 vote145 views1 answer
Oarcale list objects
SQL
0 vote168 views1 answer
How to set up an anonymous function to variable in swift
SQL
2 votes145 views2 answers
Select multiple tables mysql
SQL
0 vote169 views1 answer
Update sqlite
SQL
0 vote149 views1 answer
Suse status MySQL
SQL