/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 vote185 views1 answer
MQL4 mql4 run ea on all symbols by adding to just one chart
SQL
5 votes178 views3 answers
Sql make column nullable
SQL
1 vote191 views1 answer
Oracle check table lock
SQL
0 vote188 views1 answer
Mariadb search columns
SQL
0 vote187 views1 answer
Get primary key of table
SQL
3 votes269 views4 answers
Sql interview questions
SQL
1 vote147 views1 answer
Into sql
SQL
0 vote189 views1 answer
Get last date join sql
SQL
0 vote191 views1 answer
Zerar auto increment mysql
SQL
0 vote168 views1 answer
How to update random rows in sql
SQL