Re: TOP N syntax in Oracle 9i.

RANK would likely do what you need (Top N). Do a search for analytic functions. That will turn up what you are looking for. Also, look for analytic functions at http://asktom.oracle.com

Evan Ehrenhalt wrote:
>
> Sybrand,
>
> Thank you for the clues!
>
> Query on tahiti in "SQL Reference" yields the following results:
> Word or phrase Results
> =========================== ===================
> "select" matched 497 topics.
> "select AND rows matched 93 topics.
> "select AND first AND rows" matched 18 topics.
> "select AND rownum" matched 5 topics.
> "select AND top" matched 9 topics.
> "select AND top-N" matched 1 topic (ROWNUM).
>
> Rownum had the following as a part of it:
> > If you embed the ORDER BY clause in a subquery and
> > place the ROWNUM condition in the top-level query,
> > you can force the ROWNUM condition to be applied
> > after the ordering of the rows. For example, the
> > following query returns the 10 smallest employee
> > numbers. This is sometimes referred to as a "top-N query":
> >
> > SELECT * FROM
> > (SELECT * FROM employees ORDER BY employee_id)
> > WHERE ROWNUM < 11;
>
> For those of us who are NOT Oracle guru's, please include a buzz word to
> assist searches. Some users may have jargon from other databases or just
> not remember a synonym. The person could wind up with "RANK" or some
> other thing that is not quite what was hoped for.
>
> I have struggled with "jargon conversion" for a few months now, so I try
> to search before I ask the question, but sometimes it can not be done
> without a pointer in the right direction.
>
> Thanks,
>
> Evan
>
> Sybrand Bakker wrote:
> >
> > On Mon, 29 Apr 2002 15:58:01 +0200, "Đuro Dretvić"
> > <Djuro.Dretvic_at_Infodom.hr> wrote:
> >
> > >Greetings !!!
> > >
> > >How do I retrieve first N rows from table or view in Oracle 9i ?
> > >
> > >Example of T-SQL in MS SQL Server 2000.
> > >
> > >N= 20
> > >
> > >SELECT TOP 20 FROM DEPT;
> > >
> > >Regards Dj.
> > >
> >
> > http://tahiti.oracle.com has all 9i docs including the sql reference
> > manual. The paragraph on SELECT would typically contain the correct
> > answer.
> > Or is this a quiz question, where the correct responder earns
> > something?
> > I don't think so, you are probably just too lazy to type the URL
> >
> > Please do your homework the next time before asking mere doc
> > questions.
> >
> > Regards
> >
> > Sybrand Bakker, Senior Oracle DBA
> >
> > To reply remove -verwijderdit from my e-mail address

-- 
 -----------------------------
* http://pipers.hypermart.net *
 -----------------------------