Re: SQL Help - Selecting record based on greatest value

From: James Alexander Starritt <james_at_jamesstarritt.com>
Date: Thu, 4 Jan 2001 13:40:45 -0600
Message-ID: <932jl8$8h7i3$1@ID-68406.news.dfncis.de>

;-D wish I was young enough to be doing homework - this is Oracle on the fly with no training .....

thanks

--

James Alexander Starritt (james_at_jamesstarritt.com)


"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
news:932j6h$8lk48$5_at_ID-62141.news.dfncis.de...


> 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:40:45 CST