/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 vote202 views1 answer
Raven ql select count
SQL
0 vote203 views1 answer
Sqlcmd no headers
SQL
0 vote210 views1 answer
Sql query to force the database to be drop
SQL
0 vote216 views1 answer
Mysql query to select the highest value
SQL
4 votes215 views1 answer
Phone number sql
SQL
0 vote235 views1 answer
Wp_query raw sql
SQL
-1 vote203 views1 answer
Insert results of a stored procedure into a temporary table
SQL
0 vote192 views1 answer
IIF
SQL
1 vote182 views2 answers
OSError: mysql_config not found mysql_config --version mariadb_config --version mysql_config --libs ---------------------------------------- ERROR: Command errored out with exit status 1: python setup.py egg_info Check the logs for full command outpu
SQL
2 votes207 views1 answer
Apex date today add days
SQL