/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 vote141 views1 answer
Microsoft word insert sql code
SQL
5 votes157 views3 answers
Sql server utc to local
SQL
1 vote130 views1 answer
Can we drop a primary key
SQL
0 vote234 views1 answer
Drop check command
SQL
0 vote153 views1 answer
HOW to select specific table data from an mysql databse server:
SQL
3 votes142 views2 answers
Having in mysql
SQL
0 vote145 views1 answer
Laravel eloquent get generated sql
SQL
-1 vote148 views1 answer
Sql set max value in column
SQL
4 votes211 views1 answer
Mysql store ip address
SQL
0 vote154 views1 answer
Compare if is null sql
SQL