/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 vote221 views1 answer
Pgsql sum switch case
SQL
1 vote214 views4 answers
Postgres extract date from timestamp
SQL
2 votes206 views1 answer
Update trigger
SQL
0 vote220 views1 answer
Sqlite3 pragma foreign keys
SQL
5 votes219 views3 answers
Day of week postgresql
SQL
2 votes178 views1 answer
Select sid oracle
SQL
3 votes241 views2 answers
Oracle drop sequence
SQL
-2 votes226 views1 answer
Trunc in sql
SQL
6 votes223 views2 answers
If not exists insert sql
SQL
0 vote191 views1 answer
Separator mysql
SQL