/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 vote293 views3 answers
Connection string mysql
SQL
1 vote310 views1 answer
How to delay stored procedure execution in sql server
SQL
7 votes290 views5 answers
Show details of table postgres
SQL
2 votes291 views2 answers
HOW TO FIND MEDIAN IN SQL FOR BOTH IDD AND EVEN
SQL
0 vote277 views1 answer
Sql server udf performance
SQL
0 vote280 views1 answer
Sql column as header
SQL
0 vote274 views1 answer
Mysql show foreign keys column
SQL
0 vote281 views1 answer
Extract sql from query object sqlalchemy
SQL
1 vote286 views1 answer
Postgres start database on linux
SQL
5 votes288 views3 answers
Oracle first day of last year
SQL