/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 vote213 views1 answer
How to check rollback status in oracle
SQL
0 vote181 views1 answer
Mysql check datetime equals date
SQL
0 vote164 views1 answer
How to export table data from mysql table in sql format
SQL
6 votes177 views2 answers
Oracle trigger
SQL
-1 vote214 views4 answers
Sql view postgresql
SQL
0 vote225 views1 answer
Drop view sql
SQL
0 vote182 views1 answer
Mysql get date diff in months
SQL
0 vote161 views4 answers
Mysql select bottom 10 rows
SQL
0 vote158 views1 answer
Psql check if value in array
SQL
3 votes171 views3 answers
C# sql select
SQL