Path: news.f.de.plusline.net!news-fra1.dfn.de!newsfeed.hanau.net!newsfeed2.scan-plus.net!news.germany.com!postnews.google.com!h2g2000hsg.googlegroups.com!not-for-mail From: Mariano Newsgroups: comp.databases.oracle.misc Subject: use of ROWNUM Date: 5 May 2007 06:35:37 -0700 Organization: http://groups.google.com Lines: 10 Message-ID: <1178372136.972480.217410@h2g2000hsg.googlegroups.com> NNTP-Posting-Host: 82.51.134.222 Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" X-Trace: posting.google.com 1178372137 24576 127.0.0.1 (5 May 2007 13:35:37 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Sat, 5 May 2007 13:35:37 +0000 (UTC) User-Agent: G2/1.0 X-HTTP-UserAgent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X; it; rv:1.8.1.3) Gecko/20070309 Firefox/2.0.0.3,gzip(gfe),gzip(gfe) Complaints-To: groups-abuse@google.com Injection-Info: h2g2000hsg.googlegroups.com; posting-host=82.51.134.222; posting-account=1fyMmA0AAAC1z-LgPY-6ujNerYIq6BaP Xref: news.f.de.plusline.net comp.databases.oracle.misc:79112 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?