Contact Doug!
Learn About Doug!
View Doug Boude's online resume
updated 11/18/2009

View Doug Boude's profile on LinkedIn
Link to me!

Follow Doug Boude on Twitter
Follow me!

Be Doug's friend on Facebook
Befriend me!
(I promise not to follow you home)
OO Lexicon
Chat with Doug!
Recent Entries
You may also be interested in...
Web Hosting

<< April, 2014 >>
Search Blog

Recent Comments
Re: Basic Ajax Select List Filter in PHP (by good at 2/04 5:26 AM)
Re: Family Law: The Weapon of Choice for Woman Scorned (by swalker at 2/03 2:15 AM)
Re: Approaches to Building Strings: The Imploding Array (by bantal silikon at 2/01 9:44 PM)
Re: Disappearing IE Popup Window During Save/Open Dialog (by AddisonDean at 1/15 9:59 AM)
Re: My Top 20 Life Lessons for Boys and Young Men (by Alex at 1/13 8:45 PM)
Re: Array Loop Modifications in CFSCRIPT (by Alex at 11/25 11:18 AM)
Re: Array Loop Modifications in CFSCRIPT (by Abram at 11/14 11:32 PM)
Re: Recursive Functions in ColdFusion (by Dwayne at 10/25 3:47 PM)
Re: Porting Coldfusion Code to Mura (by dh at 10/16 10:14 AM)
Re: Viewing Option Text (in IE7) that's Wider than the Select List (by Devil May Cry at 9/26 1:38 AM)
Re: Why I Hate ORMs (a solicited rant) (by guideX at 9/12 11:38 PM)
Re: Recursive Functions in ColdFusion (by KP at 8/08 7:13 PM)
Re: American Airlines, YOU SUCK! (by Alison at 7/23 4:48 PM)
Re: SQL Forward Engineering with Visio 2003 Professional (by Harshad at 7/11 9:17 AM)
Re: Disappearing IE Popup Window During Save/Open Dialog (by LZ at 4/20 7:58 AM)
Re: Create Dynamic WHERE Clauses in PHP (by pooja at 3/20 7:29 AM)
Re: Just What IS a 'Service Layer', Anyway? (by EugenK at 3/07 7:56 PM)
Re: Using Google as your CF Mail Server (by at 2/25 1:27 AM)
Re: Why Provide for Service layer objects in CFWheels? (by Steven Benjamin at 1/25 11:43 AM)
Re: What is an 'Advanced' Coldfusion Developer? (by ColdFusion Developer at 12/24 5:14 AM)
Photo Albums
Funnies (5)
Family (3)

Powered by
BlogCFM v1.11

24 June 2006
Equivalent of SQL "TOP X" in Oracle
A friend asked me a good question, so thought I'd share it and the answer for whomever it may help in the future.

Q:  What is the equivalent of the SQL statement "SELECT TOP 10 * FROM myTable" in Oracle?


Posted by dougboude at 2:06 AM | PRINT THIS POST! |Link | 3 comments
Subscription Options

You are not logged in, so your subscription status for this entry is unknown. You can login or register here.

Re: Equivalent of SQL "TOP X" in Oracle
thank you
Posted by Azzedo on July 1, 2009 at 4:39 PM

Re: Equivalent of SQL "TOP X" in Oracle
Hi mates,

Well, Firstly I have to thank you for you tip, it's pretty useful when we facing such situation.

Just to complete this article, the TOP function from SQL processes first the order by clause and after the TOP function... on oracle databases we have to do a "workaround" to get the expected result as shown below:


it's going to process the order by clause followed by the WHERE clause.

I know it's not even close the best solution but can save a good time.


Paulo Miguel Almeida
Twitter: @paulomigueljava
Posted by Paulo Miguel Almeida on July 13, 2011 at 1:35 PM

Re: Equivalent of SQL "TOP X" in Oracle
thank you very much it worked for me.
Posted by Ashenafi Desalegn on December 6, 2012 at 5:29 AM

Name:   Required
Email:   Required your email address will not be publicly displayed.

Want to receive notifications when new comments are added? Login/Register for an account.

Time to take the Turing Test!!!

Four plus Twenty equals
Type in the answer to the question you see above:

Your comment:

Sorry, no HTML allowed!