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: Select max

Re: Select max

From: TurkBear <jgreco1_at_mn.rr.com>
Date: Mon, 22 Jul 2002 08:47:38 -0500
Message-ID: <f33ojust1gnlpsfo67ui3r39tfuvh0il0l@4ax.com>


Try the docs on using Sql :
Select * from table where field1 = ( select max(field1) from table)

"Leonardo Lombardo" <leo.lombardo_at_inwind.it> wrote:

>Hi all,
>
>I mean "where the value in that column is the maximum value
> that can be found on that column in all that table".
>
>Hope is precise now, tahnks.

-----------== Posted via Newsfeed.Com - Uncensored Usenet News ==----------

   http://www.newsfeed.com The #1 Newsgroup Service in the World! -----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers =----- Received on Mon Jul 22 2002 - 08:47:38 CDT

Original text of this message

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