"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 - 02:50:01 CDT
