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 vote355 views1 answer
Import big data to mysql
SQL
0 vote419 views1 answer
Postgres - Login and connect as default user
SQL
0 vote396 views1 answer
Sql select without column name
SQL
0 vote389 views1 answer
Mysql where don't have string
SQL
1 vote378 views2 answers
Logical operators in sql
SQL
50 votes438 views6 answers
Sql duplicate rows
SQL
40 votes468 views4 answers
PostgreSQL add column
SQL
4 votes347 views2 answers
Dbms_scheduler stop job
SQL
5 votes374 views3 answers
MySql get fields of table
SQL
-1 vote386 views1 answer
How to change the auto increment in existing table mysql
SQL