/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

9 votes128 views3 answers
Sql delete where in
SQL
22 votes142 views3 answers
Remove all records from table mysql
SQL
21 votes171 views3 answers
Average sql
SQL
51 votes349 views6 answers
Installing mysql on ubuntu
SQL
0 vote126 views1 answer
Xampp increame mysql speed
SQL
3 votes134 views3 answers
How to set up an auto incrementing id db browser
SQL
3 votes169 views2 answers
@sqlresultsetmapping
SQL
0 vote161 views1 answer
How to drop a column in mysql laravel stackoverflow
SQL
0 vote131 views1 answer
Plpgsql raise notice
SQL
0 vote126 views1 answer
Sql join on a subquery
SQL