/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 vote251 views1 answer
Python escape string for sql
SQL
3 votes280 views1 answer
Postgresql db owner change
SQL
7 votes289 views3 answers
How ot change name of column mysql
SQL
5 votes317 views4 answers
SQL Order of execution
SQL
0 vote316 views1 answer
New rails app with mysql
SQL
0 vote281 views1 answer
Flask sqlalchemy remove duplicates
SQL
4 votes275 views1 answer
Select first and last row sql
SQL
1 vote306 views1 answer
Mysql last year
SQL
0 vote244 views1 answer
Sql truncate table referencing itself
SQL
0 vote298 views1 answer
Command to give readonly access to a postgres sql user
SQL