FYI in oracle the "top" select is handled by the ROWNUM pseudocolumn...
i.e. SELECT myfield FROM mytable WHERE ROWNUM<=10;
Jeremy Brodie
Edgewater Technology
web: http://www.edgewater.com
phone:(703) 815-2500
email: [EMAIL PROTECTED]
> In oracle, there is no 'top' select. In the scenario given, a sub
> select is the most efficient.
>
> My apology for not having asked Dan what DB he was using.
>
> Nick Han
>
> >>> [EMAIL PROTECTED] 02/17/04 10:53AM >>>
> Why not select them ordered by date_modified and then just use the
> first
> record? Or if you're worried about passing all of that data back and
> forth you can use TOP (or whatever corresponds to your DB server)
>
> John Burns
>
> -----Original Message-----
> From: Steve Milburn [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, February 17, 2004 1:51 PM
> To: CF-Talk
> Subject: Re: query help...
>
> Daniel Farmer wrote:
>
> > This is my query...
> >
> > select * from estates where featured = 1 and
> >
> > [ I want to select the oldest date_modified field here ]
> >
> >
> >
> > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> > Daniel Farmer
> > Coldfusion Developer / Sales / Producer
> > 613.284.1684
> >
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
