/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 vote108 views1 answer
Increment id in mysql
SQL
0 vote121 views1 answer
Html css mobile menu arrow dropdown
SQL
0 vote246 views1 answer
Sql change a colum to unique
SQL
5 votes116 views3 answers
How to remove unique key constraint in mysql
SQL
0 vote124 views1 answer
Oracle running queries sql
SQL
4 votes162 views2 answers
Sql select except null
SQL
5 votes83 views1 answer
Alter table default value mysql
SQL
3 votes126 views3 answers
Raw select laravel
SQL
0 vote123 views2 answers
Sql query for getting details by id
SQL
11 votes119 views2 answers
Oracle source code
SQL