/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

4 votes299 views2 answers
Insert current date in mysql
SQL
1 vote329 views2 answers
Oracle difference between two dates in seconds
SQL
0 vote302 views1 answer
Create table Statement Syntax in SQL Server
SQL
0 vote295 views1 answer
2020 new year
SQL
0 vote304 views1 answer
Sql server select furst day of current year
SQL
0 vote270 views1 answer
Big query add table rows to another table
SQL
3 votes289 views1 answer
Oracle function
SQL
1 vote319 views1 answer
Replace all numbers in mysql
SQL
2 votes317 views1 answer
Scaffold npgsql net core
SQL
31 votes322 views4 answers
Mysql grant execute
SQL