/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 vote329 views1 answer
Datagrip exec
SQL
0 vote367 views1 answer
Mysqli::query(): (HY000/1034): Index for table 'db' is corrupt; try to repair it
SQL
7 votes295 views6 answers
Code: 'er_not_supported_auth_mode', errno: 1251, sqlmessage: 'client does not support authentication protocol requested by server; consider upgrading mysql client', sqlstate: '08004', fatal: true
SQL
0 vote344 views1 answer
Sql getdate minus 1 day without time
SQL
0 vote351 views1 answer
How to run mysql in git bash
SQL
5 votes359 views1 answer
Oracle list days between two dates
SQL
0 vote341 views1 answer
Sql select most frequent value in column
SQL
3 votes339 views2 answers
Oracle drop column
SQL
1 vote327 views1 answer
How to give access to database in postgresql server to another user
SQL
0 vote290 views1 answer
Query for maximum salary
SQL