/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 vote207 views1 answer
How to install mysql without admin rights
SQL
0 vote199 views1 answer
Grant access on table in oracle
SQL
2 votes211 views1 answer
Compare date in sql
SQL
0 vote235 views1 answer
Postgresql CREATE EXTENSION pgcrypto
SQL
0 vote192 views1 answer
Mysql search multiple tables
SQL
-1 vote193 views1 answer
Search all tables all columns for a specific value in mssql-server
SQL
0 vote266 views1 answer
Sql query for login with email or username
SQL
0 vote196 views1 answer
Cannot create a JSON value from a string with CHARACTER SET 'binary'.
SQL
15 votes282 views6 answers
Drop foreign key mysql
SQL
3 votes147 views1 answer
How to get list of synonyms in oracle
SQL