that impossible.
Timothy Heald
Information Systems Manager
Overseas Security Advisory Council
U.S. Department of State
571.345.2319
The opinions expressed here do not necessarily reflect those of the U.S.
Department of State or any affiliated organization(s). Nor have these
opinions been approved or sanctioned by these organizations. This e-mail is
unclassified based on the definitions in E.O. 12958.
-----Original Message-----
From: Thomas Chiverton [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 15, 2003 8:24 AM
To: CF-Talk
Subject: Re: Top n in Oracle
On Wednesday 15 Oct 2003 12:39 pm, Heald, Tim wrote:
> I need to pull Top n (lets say three) from an oracle 8i db. Now SQL
Server
> makes this really easy to do. How would I go about doing it in Oracle? I
> have tried sub selects and rownum and stuff, but the order gets al hosed
up
> if I use those. Basically I need them ordered by date desc.
Do that, then only print the first three rows - you can access your query as
a
structure remember !
--
Tom Chiverton
Advanced ColdFusion Programmer
Tel: +44(0)1749 834997
email: [EMAIL PROTECTED]
BlueFinger Limited
Underwood Business Park
Wookey Hole Road, WELLS. BA5 1AF
Tel: +44 (0)1749 834900
Fax: +44 (0)1749 834901
web: www.bluefinger.com
Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple
Quay, BRISTOL. BS1 6EG.
*** This E-mail contains confidential information for the addressee
only. If you are not the intended recipient, please notify us
immediately. You should not use, disclose, distribute or copy this
communication if received in error. No binding contract will result from
this e-mail until such time as a written document is signed on behalf of
the company. BlueFinger Limited cannot accept responsibility for the
completeness or accuracy of this message as it has been transmitted over
public networks.***
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
