/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 vote383 views4 answers
Creating a comment and reply system PHP and MySQL
SQL
1 vote341 views1 answer
MYSQL HOT TO COUNT THE DURATION BETWEEN TWO DATES
SQL
3 votes347 views1 answer
Oracle apex warn on unsaved changes
SQL
-1 vote382 views2 answers
Mysql get day of week
SQL
0 vote391 views1 answer
What is SQL data store?
SQL
0 vote359 views1 answer
How to add timestamp column in mysql
SQL
0 vote352 views1 answer
Mysql update from n to 100
SQL
0 vote372 views2 answers
Homebrew nysql launch
SQL
0 vote378 views2 answers
Sql having multiple conditions
SQL
1 vote361 views3 answers
Divide by zero error in sql
SQL