/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

2 votes194 views1 answer
Get the mysql table columns data type mysql
SQL
1 vote149 views1 answer
Simple project for database
SQL
2 votes133 views1 answer
Wait delay in sql server
SQL
0 vote152 views1 answer
Sql column contains special character
SQL
1 vote113 views1 answer
Import in mysql without a software
SQL
0 vote107 views1 answer
Resolved [java.sql.SQLException: ORA-29977: Unsupported column type for query registration in guaranteed mode ]
SQL
1 vote147 views1 answer
Truncate left characters mysql
SQL
0 vote183 views1 answer
Update sql sintax
SQL
1 vote165 views3 answers
SELECT * FROM
SQL
0 vote143 views1 answer
Postgres : ERROR: division by zero
SQL