/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 vote281 views1 answer
Alter rename command in mysql
SQL
8 votes283 views3 answers
Alter user root mysql
SQL
0 vote270 views1 answer
Tsql generate rows
SQL
6 votes225 views2 answers
Generate c# class from sql server table
SQL
1 vote283 views1 answer
Postgresql export output table as a csv
SQL
0 vote264 views1 answer
Sql last 7 days
SQL
0 vote283 views2 answers
Sql last updated
SQL
11 votes282 views2 answers
Insert date sql
SQL
7 votes258 views2 answers
Get database size mysql
SQL
0 vote259 views1 answer
Getting next sequence value jpa postgress
SQL