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 vote203 views1 answer
List MySQL Table and Index Size
SQL
0 vote233 views1 answer
Parent and child link in mysql
SQL
17 votes241 views2 answers
T_sql contains
SQL
0 vote219 views2 answers
Postgresql gset
SQL
0 vote236 views1 answer
Combine 2 columns search query mysql
SQL
0 vote225 views1 answer
How to select only a certain date sql
SQL
0 vote197 views1 answer
Shell script to log mysql cpu usage
SQL
2 votes225 views2 answers
Postgres change owner of schema
SQL
0 vote205 views2 answers
Sqlite unix timestamp
SQL
0 vote203 views1 answer
RowDataPacket
SQL