/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 vote371 views1 answer
How to get button for every record from mysql
SQL
0 vote322 views1 answer
How to set all the min and sec data to zero in sql server
SQL
4 votes316 views2 answers
Mysql show indexes on table
SQL
0 vote323 views1 answer
Mysql conf.d exampel
SQL
0 vote325 views1 answer
Setval postgres example table id
SQL
0 vote343 views1 answer
How to insert multiple values in a single column in sql
SQL
1 vote339 views1 answer
Drop column if exists sql server
SQL
1 vote316 views1 answer
Mysql count words
SQL
0 vote315 views1 answer
Pl/sql loop example
SQL
0 vote304 views1 answer
Generate sequence number in sql server
SQL