Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: use of ROWNUM

Re: use of ROWNUM

From: <valiveru_at_gmail.com>
Date: 9 May 2007 14:21:54 -0700
Message-ID: <1178745714.835765.210770@e51g2000hsg.googlegroups.com>


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;

Received on Wed May 09 2007 - 16:21:54 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US