/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 vote151 views1 answer
Postgres list users and roles
SQL
0 vote134 views2 answers
Close external port 3306 with iptables
SQL
7 votes129 views3 answers
Python and mysql connectivity
SQL
1 vote206 views1 answer
Sql injection
SQL
7 votes102 views1 answer
Safe mode mysql
SQL
0 vote131 views2 answers
Mysql dump database tables only
SQL
0 vote130 views1 answer
Postgres multiple left join causing duplicates jsonb_agg
SQL
37 votes124 views3 answers
Postgresql insert column
SQL
2 votes123 views1 answer
Mysql sql add created updated timestamp to existing table
SQL
2 votes125 views1 answer
Drop table if exists in postgres
SQL