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

0 vote320 views1 answer
Set Mamp mysql globally
SQL
0 vote359 views1 answer
Mysql convert charset
SQL
0 vote314 views1 answer
Count in sql and diff
SQL
0 vote313 views2 answers
Postgresql change user role grant
SQL
2 votes288 views1 answer
How to select first row of database sql
SQL
6 votes285 views1 answer
Oracle trigger after connect
SQL
0 vote332 views1 answer
Sqlcl format
SQL
5 votes355 views3 answers
Sql limit offset
SQL
0 vote328 views1 answer
BigQuery Remove Duplicate Keys From Table
SQL
0 vote328 views1 answer
Running mysql from bash sc
SQL