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 vote280 views1 answer
Mysql export search results
SQL
0 vote281 views1 answer
Sql query to get contact form 7 fields
SQL
0 vote278 views1 answer
Mysql join only one column
SQL
6 votes278 views1 answer
Wordpress change user password sql
SQL
1 vote280 views1 answer
Md5 encryption for existing records
SQL
0 vote282 views2 answers
Psql commande \gset
SQL
1 vote287 views1 answer
Setval pgsql
SQL
0 vote286 views1 answer
Print boolean in plsql
SQL
0 vote258 views1 answer
Postgresql add not null and not empty constraint
SQL
-1 vote266 views1 answer
Ssms connect with connection string
SQL