( SELECT *
FROM foo
WHERE goo = 'koo'
ORDER BY gooey
)
WHERE rownum < 101
----- Original Message -----
From: "Heald, Tim" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, October 15, 2003 6:39 AM
Subject: Top n in Oracle
> 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.
>
> Any help would be appreciated.
>
> 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.
>
>
>
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
