Re: Limit lines from a query

From: <liam_2e_at_my-deja.com>
Date: 2000/03/10
Message-ID: <8abko7$v1a$1@nnrp1.deja.com>#1/1

Hi use

rownum<11

In article <38C92967.97083664_at_gmx.de>,
Franz-Josef Vorspohl <fj.vorspohl_at_gmx.de> wrote:
> I want to limit the lines from a query with
> GROUP BY
> ORDER BY
>
> I want to select only the 10 greatest lines-
>
> I fond only the following way
>
> 1. execute the query
> 2. take the 10th line
> 3. execute the query with a HAVING statement
>
> It es possible to limit direct the lines from a query?
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Mar 10 2000 - 00:00:00 CST