Re: Reduce data returned by a query

elziko wrote:

> If I have a query such as :
>
> SELECT mycolumn FROM mytable;
>
> ...which returns eight rows like so:
>
> "One"
> "Two"
> "Three"
> "Four"
> "Five"
> "Six"
> "Seven"
> "Eight"
>
> Is it possible to return only every OTHER row? So that only the odd numbered
> rows are returned like so:
>
> "One"
> "Three"
> "Five"
> "Seven"
>
> I know I can just get rid of my data after the query but then I'm wasting
> the DB access time getting data I dont want.
>
> Many thanks,
>
> elziko

Use an in-line view and the mod() function.

Is this for a class?

Daniel Morgan Received on Fri Jan 24 2003 - 14:30:41 CST