/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

4 votes185 views4 answers
Start mysql
SQL
0 vote179 views1 answer
NLS_NCHAR_CHARACTERSET
SQL
0 vote217 views1 answer
Sql server delete records with specific date
SQL
0 vote235 views2 answers
The metadata storage is not up to date, please run the sync-metadata-storage command to fix this issue.
SQL
5 votes179 views1 answer
Mysql add user with all privileges
SQL
4 votes187 views2 answers
Oracle set date format
SQL
1 vote180 views1 answer
Get rows affected mysql python
SQL
0 vote187 views2 answers
How to update the multiple rows in sql
SQL
1 vote178 views1 answer
User privileges postgresql information_schema
SQL
0 vote177 views1 answer
"SET SQL_AUTO_IS_NULL = 0" query problem
SQL