Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Limit lines from a query

Limit lines from a query

From: Franz-Josef Vorspohl <fj.vorspohl_at_gmx.de>
Date: 2000/03/10
Message-ID: <38C92967.97083664@gmx.de>#1/1

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? Received on Fri Mar 10 2000 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US