/SQL/How to fetch alternate records from two tables

How to fetch alternate records from two tables

To fetch even Numbered row:

SELECT * FROM table_name WHERE column_name % 2 = 0

To fetch odd Numbered row:

SELECT * FROM table_name WHERE column_name % 2 = 1

Source: stackoverflow.com

Similar codes

0 vote180 views1 answer
Finding leap year in sql
SQL
-1 vote165 views4 answers
Restart mysql server ubuntu
SQL
0 vote183 views1 answer
Sql remove decimal places
SQL
2 votes154 views3 answers
Sqlite3.OperationalError: near "7": syntax error
SQL
0 vote170 views1 answer
Createdb with postgresql on ubuntu
SQL
0 vote147 views1 answer
Mysql table variables
SQL
0 vote158 views1 answer
Oracle synonym procedure dblink
SQL
22 votes156 views4 answers
Mysql reset auto increment id
SQL
0 vote147 views2 answers
Find Overlapping sql
SQL
3 votes161 views2 answers
Df to sql pandas sql achemy
SQL