Select max

From: Leonardo Lombardo <leo.lombardo_at_inwind.it>
Date: Mon, 22 Jul 2002 10:19:59 +0000 (UTC)
Message-ID: <92a335d0e9cd9712defc44fee77a039c.69477@mygate.mailgate.org>

Hi all,

my question/problem is:

I want to select a row from a table where one of its field has the maximum value in that table. For example:

Table FOO

           id     number
      afield    varchar2
      bfield    date

How can I write an sql statement that selects the whole row in which bfield is max ?

Thanks in advance, Leonardo

-- 
Posted via Mailgate.ORG Server - http://www.Mailgate.ORG

Received on Mon Jul 22 2002 - 05:19:59 CDT