No rowcount will not work. Because it will only order the records within the rowcount, not all the records:
select totalsales from salesperson where rowcount < 10 orderby totalsales DESC Will only order and return the first ten salespersons in the table, not the first ten of of the whole table... > VAN VLIET, SCOTT E (SBCSI) wrote: > > >Sorry for the OT, but do any of you know the Oracle function for selecting > >the top n records. (ie. SELECT TOP 10 * FROM TABLE - in SQL). > > > >Thanks! > > > >Scott > > > rowcount is similar but my oracle skills have bit rotted :-( i think :-) > > z > > > ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
