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 votes326 views1 answer
Mysql store ip address
SQL
0 vote280 views1 answer
Find all tables where column name exists oracle
SQL
-1 vote266 views2 answers
How to display top 50 rows?
SQL
0 vote285 views1 answer
What is ssrs and ssis in sql server
SQL
0 vote233 views1 answer
Postgresql add leading zeros
SQL
0 vote308 views1 answer
Sql date time query find
SQL
1 vote306 views1 answer
Oracle sql pad left zeros
SQL
0 vote283 views1 answer
Liquibase update row
SQL
2 votes297 views1 answer
Sql server case sensitive search
SQL
1 vote239 views1 answer
Mysqldump: couldn't execute 'select column_name,
SQL