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 -> use of ROWNUM

use of ROWNUM

From: Mariano <mariano.calandra_at_gmail.com>
Date: 5 May 2007 06:35:37 -0700
Message-ID: <1178372136.972480.217410@h2g2000hsg.googlegroups.com>


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? Received on Sat May 05 2007 - 08:35:37 CDT

Original text of this message

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