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 votes236 views2 answers
How to count items with same name in sql
SQL
0 vote258 views1 answer
Call rest api from postgresql
SQL
4 votes270 views1 answer
Oracle error line
SQL
31 votes241 views3 answers
Sql count(*)
SQL
0 vote261 views1 answer
Mysql not defined
SQL
0 vote251 views1 answer
How should I pass a table name into a stored proc?
SQL
0 vote259 views1 answer
Alter database name script
SQL
2 votes269 views1 answer
How to Add a Default Value to a Column in MS SQL Server
SQL
0 vote249 views2 answers
How to save result of sqlite query in a table
SQL
1 vote414 views3 answers
Create table from existing table in sql
SQL