/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 vote111 views1 answer
Sql how to display two atributes as one in sql
SQL
2 votes112 views2 answers
Exec procedure pl sql
SQL
0 vote120 views1 answer
Connexion mysql
SQL
0 vote124 views1 answer
Restart sql server command line linux
SQL
0 vote116 views1 answer
List all indexes postgres
SQL
7 votes114 views1 answer
Mysql remote connection command line
SQL
2 votes127 views3 answers
Postgres json to string
SQL
0 vote114 views1 answer
Sql server remove 0 from left
SQL
0 vote107 views1 answer
Sql select rows between 1000 and 2000
SQL
0 vote105 views1 answer
How to remove default in mysql
SQL