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

2 votes300 views3 answers
Sqlite3.OperationalError: near "7": syntax error
SQL
0 vote247 views1 answer
Get number of table colums in sql query
SQL
0 vote279 views1 answer
Mysql join same table multiple times group by
SQL
0 vote268 views1 answer
Mysql_union
SQL
0 vote289 views1 answer
Flush user resource mysql
SQL
0 vote289 views1 answer
Sql developer search all packages for text
SQL
10 votes254 views1 answer
Oracle dependency
SQL
0 vote312 views1 answer
Mariadb cast to int
SQL
-1 vote275 views2 answers
Get day in sql
SQL
1 vote313 views1 answer
Mysql find most common value
SQL