/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

14 votes172 views3 answers
Alter foreign key
SQL
12 votes164 views2 answers
Delete all nodes neo4j
SQL
58 votes548 views4 answers
Mysql drop column
SQL
0 vote239 views2 answers
Install phoenix
SQL
0 vote214 views2 answers
Dbms interview questions
SQL
0 vote263 views1 answer
Import sql dump into postgresql database
SQL
1 vote177 views2 answers
Begin transaction in sql
SQL
7 votes178 views1 answer
Grant schema permissions postgres
SQL
0 vote176 views2 answers
Msg 8164, Level 16, State 1, Procedure getSalaryMonth, Line 31 [Batch Start Line 13] An INSERT EXEC statement cannot be nested.
SQL
0 vote179 views1 answer
Failed to connect to localhost:1433 - self signed certificate
SQL