Re: use of ROWNUM

On May 5, 10:35 am, Mariano <mariano.calan..._at_gmail.com> wrote:
> Then I have this query result:
>
> >select * from analisi_ricovero WHERE id_ric=82
>
> ID_ANL ID_RIC INDATA VALORE
> 41 82 29-APR-07 11.54.17,000000 PM 43
> 41 82 29-APR-07 11.54.10,000000 PM 5
>
> Now I only need ID_ANL, ID_RIC and INDATA with MAX INDATA value, how
> can obtain it?

select id_anl, id_ric, max(indata)
from analisi_ricovero
where id_ric=82
group by id_anl, id_ric Received on Sun May 06 2007 - 07:02:48 CDT