Oracle rank function and MySQL
Hi everybody,
I have to retrieve the last record in each group.
In Oracle I could achieve this easily using partition and rank function.
Is there in Mysql a similar function (or a trick) or
have I to query the same table twice or three times and join the results to achieve it?
Thanks a lot
Stefano
Subject
Views
Written By
Posted
Oracle rank function and MySQL
25664
June 11, 2006 05:56AM
14812
June 11, 2006 07:27AM
12438
March 24, 2008 01:24PM
9449
June 11, 2006 09:25AM
8369
December 25, 2006 03:50AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.