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 vote299 views1 answer
How to connect to mysql in ef 6
SQL
0 vote301 views1 answer
Rabbitmq service not starting
SQL
0 vote374 views1 answer
SQLSTATE[42000]: Syntax error or access violation: 1140 Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
SQL
3 votes337 views1 answer
Flutter sqlite auto incrementing id primary key
SQL
39 votes376 views5 answers
Sql drop column
SQL
11 votes321 views3 answers
Change column name sql server management studio
SQL
0 vote345 views1 answer
Mysql error 1114 (hy000) the table is full
SQL
0 vote355 views2 answers
How to truncate all table in mysql workbench
SQL
0 vote285 views1 answer
Count column of tables psql
SQL
5 votes265 views1 answer
Copy table from one database to another mysql
SQL