/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 vote234 views1 answer
Count column of tables psql
SQL
0 vote214 views1 answer
Show table structure mysql console
SQL
2 votes215 views2 answers
How to import large sql file in phpmyadmin in ubuntu
SQL
0 vote190 views1 answer
Get number of tables in database sql
SQL
0 vote197 views1 answer
Apex for oracle 11g
SQL
0 vote186 views1 answer
Restart sql server command line linux
SQL
16 votes187 views4 answers
Sort by sql
SQL
3 votes197 views2 answers
Syntax error or access violation: 1701 Cannot truncate a table referenced in a foreign key constraint
SQL
8 votes194 views2 answers
Replace string value in sql
SQL
0 vote220 views1 answer
Print intervals of 15 minutes in sql query
SQL