/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 vote131 views1 answer
Table values functions in SQL
SQL
0 vote158 views1 answer
What are the advantages of MySQL when compared with Oracle?
SQL
0 vote136 views1 answer
R write csv without index
SQL
0 vote154 views1 answer
Postgres full text search example
SQL
2 votes147 views2 answers
Postgres timestamp to datetime
SQL
1 vote151 views1 answer
Postgresql filter on
SQL
0 vote126 views1 answer
Learn sqlite dart
SQL
12 votes142 views6 answers
Select distinct
SQL
6 votes137 views5 answers
Sql add months to date
SQL
1 vote122 views1 answer
Set statistics on in ssms
SQL