Re: use of ROWNUM

Analytic function:

select ID_ANL,ID_RIC,INDATA from (
select ID_ANL,ID_RIC,INDATA,max(INDATA) over(partition by id_ric) max_indata, VALORE from analisi_ricovero WHERE id_ric=82 )
where indata = max_indata;

• Siva