/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 vote158 views1 answer
Mssql last day of month
SQL
1 vote160 views1 answer
How to see all table partition in oracle
SQL
0 vote163 views1 answer
Create query in where clasue
SQL
0 vote152 views1 answer
Mysql update from select on same table
SQL
0 vote170 views4 answers
Convert databse to achieve log mode oracle
SQL
0 vote144 views1 answer
Get null value in sql
SQL
4 votes173 views2 answers
Raise errors.NotSupportedError( mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported
SQL
0 vote143 views1 answer
Longtext sql
SQL
0 vote131 views1 answer
Export partttion and import in oracle
SQL
0 vote207 views1 answer
Do you know sql
SQL