Question

Write a sql query to fetch only even rows from table

Answer 1

Explanation:

Write a subquery with an ORDER BY clause. Along with the data columns, select the pseudocolumn rownum with an alias, say rn.

In the outer query, reference the alias rn and use the mod function to get odd rows or even rows