Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: how/what should be the query for this result
> For example:
>
> select p_no, b_no, status, build_date from (
> select p_no, b_no, status, build_date, rank()
> over (partition by p_no, b_no order by build_date desc) r
> from progress
> ) where r = 1;
>
> Notes:
> - I assume that p_no is part of the key (it's not clear)
> - if there are more than one rows with the same maximal build_date
> it will return all of them
>
> --
> Michal Kuratczyk
Thanks! Received on Thu Jun 29 2006 - 00:29:07 CDT