Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Select max
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