/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

1 vote104 views3 answers
Rename table snowflake
SQL
1 vote353 views1 answer
Sequence item 6 expected str instance bytes found mysql workbench
SQL
1 vote108 views2 answers
T-sql random number for each row
SQL
0 vote119 views1 answer
Create tables from xsd to sql server database c#
SQL
0 vote126 views1 answer
Postgres list all triggers
SQL
0 vote157 views1 answer
Select true if exists on another table or false sqlserver
SQL
17 votes105 views6 answers
Mysql import sql file
SQL
0 vote108 views1 answer
Sql with example
SQL
0 vote110 views1 answer
Get db connection detail from sql developer profile
SQL
1 vote57 views1 answer
Oracle character set
SQL