How to select the even rows in a table?

    Requires Free Membership to View

I'm assuming that you are looking for the even numbered rows in the table. But this implies that the rows have a specific order so that you can return the 2nd, 4th and 6th rows, and so on. Relational database theory holds that rows do not have any specific order. So it is not possible to return the even numbered rows from any table.

This was first published in August 2006

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.