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 votes115 views1 answer
Adding data to table in sql python
SQL
1 vote132 views1 answer
Continue in sql
SQL
0 vote116 views1 answer
Mysql value ends with
SQL
1 vote100 views1 answer
Local sql server
SQL
0 vote99 views1 answer
Add column not null with default value postgres
SQL
0 vote110 views1 answer
How to find database collation in postgres
SQL
0 vote107 views1 answer
How to check xampp mysql password
SQL
2 votes114 views2 answers
Select sqlite3.OperationalError: no such column:
SQL
8 votes124 views2 answers
How to fetch data from database without last column
SQL
0 vote105 views1 answer
Time in sql server
SQL