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

10 votes357 views5 answers
Create table mysql query
SQL
1 vote331 views1 answer
Postgresql datetrunc too slow
SQL
2 votes332 views1 answer
Mysql now format
SQL
0 vote329 views1 answer
Import Data in MySQL without using any other software
SQL
1 vote312 views1 answer
Sql myisam vs innodb
SQL
0 vote339 views1 answer
Sql query to find difference between total no. of rows and distinct rows in sql server
SQL
0 vote340 views1 answer
Select lowest values sql
SQL
0 vote324 views3 answers
Average salary in sql
SQL
1 vote361 views1 answer
Delete mysql ubuntu 20.04
SQL
2 votes342 views1 answer
Mysql increment value by 1 in update
SQL