/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 vote240 views1 answer
After kill process Failed to start mysqld.service: Unit mysqld.service not found.
SQL
0 vote235 views1 answer
When mysql server would not work in xampp
SQL
1 vote246 views1 answer
Epoch time converter in snowflake
SQL
0 vote259 views4 answers
Creating a comment and reply system PHP and MySQL
SQL
0 vote187 views2 answers
Denormalization in sql
SQL
0 vote243 views1 answer
Get who is hired in month in sql
SQL
0 vote225 views2 answers
Azure sql-datenbank
SQL
0 vote245 views2 answers
Search stored procedures by name
SQL
3 votes269 views3 answers
Illuminate database queryexception could not find driver (sql select * from
SQL
1 vote208 views1 answer
Mysql get last insert id
SQL