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 vote159 views1 answer
Substr sql last character
SQL
4 votes184 views1 answer
Is there any command to change postgres password
SQL
2 votes114 views1 answer
Sql view column data type
SQL
28 votes165 views4 answers
Show tables mysql
SQL
0 vote203 views1 answer
Reset postgresql password windows
SQL
0 vote172 views1 answer
Postgresql delete limit
SQL
4 votes163 views1 answer
SQL order random
SQL
0 vote222 views1 answer
Check the size of the tables here ordered from the biggest size
SQL
11 votes172 views6 answers
Mysql else if
SQL
0 vote167 views1 answer
Postgres declare variable
SQL