/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 vote342 views1 answer
Sql decode
SQL
0 vote350 views1 answer
How to combine first and last nae into one columb sql
SQL
8 votes373 views3 answers
Postgres connection string
SQL
14 votes367 views2 answers
Oracle limit rows
SQL
16 votes348 views3 answers
Delete row psql
SQL
1 vote322 views1 answer
Mysql order by desc null last
SQL
0 vote329 views1 answer
Oracle select invalid views
SQL
1 vote345 views1 answer
Insert column after column mysql
SQL
1 vote335 views1 answer
Mysqlworkbench Your connection attempt failed for user 'root' from your host to server at 127.0.0.1:3306: Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/mysql/lib/plugin/caching_sha2_password.so, 2): image not found
SQL
0 vote335 views1 answer
Write sql query to show the details start from digit
SQL