Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> use of ROWNUM
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