/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 vote101 views1 answer
Mysql login console
SQL
0 vote120 views1 answer
SHOW RESULT WITHOUT ROUND IN SQL
SQL
0 vote151 views1 answer
Osm2pgsql mac
SQL
0 vote145 views1 answer
Postgresql find biggest table
SQL
20 votes107 views6 answers
Change password in mysql
SQL
0 vote130 views1 answer
Table user postgres
SQL
1 vote104 views1 answer
ORA-01950
SQL
0 vote103 views1 answer
Get create sql of hibernqte entity
SQL
1 vote113 views1 answer
Myql find duplicates
SQL
0 vote112 views1 answer
Sql decode
SQL