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

6 votes319 views3 answers
Mysql remove user privileges
SQL
23 votes311 views6 answers
How to create table in sql
SQL
0 vote318 views1 answer
Creating h2 database in relative directory eclopse
SQL
0 vote299 views2 answers
What is the default password for sql server sa
SQL
8 votes327 views2 answers
Update sql server from another table
SQL
12 votes277 views1 answer
How to change the value of a table in sql
SQL
0 vote290 views1 answer
Get yesterday date ISO in psql
SQL
25 votes318 views6 answers
Import database mysql command line
SQL
0 vote327 views1 answer
Sql sort ages
SQL
0 vote297 views1 answer
Sql server set complex constraints
SQL