/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 vote361 views1 answer
Mysql select statement after index
SQL
0 vote361 views1 answer
Sql server change schema of a table
SQL
0 vote363 views1 answer
Sql case when exists in another table
SQL
0 vote389 views1 answer
Csv to sqlite python
SQL
0 vote363 views1 answer
Django mssql backend
SQL
25 votes448 views4 answers
Import mysql dump command line
SQL
1 vote367 views1 answer
Mysql event last execution
SQL
0 vote352 views1 answer
Mysql add comment to column
SQL
0 vote407 views1 answer
Check constraint is violated
SQL
0 vote333 views1 answer
Hangfire clean script
SQL