Re: TOP N syntax in Oracle 9i.

Thanx for all your suggestions.

Regards Djuro.

"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message news:3cce4ca9$1$227$ed9e5944_at_reading.news.pipex.net...
> "Evan Ehrenhalt" <eehrenh_at_emory.edu> wrote in message
> news:3CCD8416.614F19_at_emory.edu...
> >
> > 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.
>
> I see you have found an answer now. I could also point you at
> http://www.jlcomp.demon.co.uk/faq/top_sql.html where you will find that
rank
> does in fact do exactly what you want (provided you formulate the query
> correctly). I believe that Tom Kyte also presents evidence that the
analytic
> functions outperform the traditional sql approach for problems of this
> nature.
>
>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
> *****************************************
> Please include version and platform
> and SQL where applicable
> It makes life easier and increases the
> likelihood of a good answer
>
> ******************************************
>
>
Received on Tue Apr 30 2002 - 04:15:34 CDT