/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 vote289 views1 answer
Postgresql like
SQL
12 votes268 views5 answers
Sql merge
SQL
2 votes279 views1 answer
Set auto increment from 1
SQL
1 vote279 views1 answer
Replace all numbers in mysql
SQL
0 vote296 views1 answer
Dynamic where clause in sql server stored procedure
SQL
1 vote293 views1 answer
Insert many to many sql
SQL
0 vote250 views1 answer
Sql how to display two atributes as one in sql
SQL
0 vote260 views1 answer
Sql value exists in column
SQL
8 votes280 views1 answer
Oracle search code in packages
SQL
4 votes266 views3 answers
Rename table column postgresql
SQL