/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 vote345 views2 answers
Select last 30 days sql
SQL
0 vote304 views1 answer
Mysql trim characters
SQL
16 votes391 views3 answers
Get count of duplicate records
SQL
37 votes318 views3 answers
Duplicate records in sql
SQL
0 vote320 views1 answer
Set classpath for mysql-connector.jar
SQL
0 vote354 views1 answer
Stored procedure to change name of column for all dependent tables and views
SQL
0 vote337 views1 answer
Psql get table data types
SQL
15 votes308 views3 answers
Create table with primary key auto increment in sql
SQL
58 votes618 views6 answers
Create new user in postgres
SQL
0 vote331 views1 answer
Oracle for loop on list
SQL