Re: SQL Help - Selecting record based on greatest value

Homework
But anyway

select * from foo where bar =
(select max(bar) from foo)

Hth,

Sybrand Bakker, Oracle DBA

"James Alexander Starritt" <james_at_jamesstarritt.com> wrote in message news:932ict$8iist$1_at_ID-68406.news.dfncis.de...
> I have a table we can call x ... it contains 3 field a b c
>
> assuming c is a number is it possible to select the record with the
 greatest
> value ? ... and if so does this work on date fields
>
> --
>
> James Alexander Starritt (james_at_jamesstarritt.com)
>
>
Received on Thu Jan 04 2001 - 13:24:18 CST