Selct top N stuff from aTable orderby query_seq desc. Rob On Thu, Mar 12, 2009 at 9:59 AM, Ian Skinner <h...@ilsweb.com> wrote:
> > I would like to select the last n records from a table as defined by a > sequence field. > > I tried SELECT stuff FROM aTable WHERE rownum < n ORDER BY query_seq desc. > > But this just sorts the first n records in descending order where I want > the last n records. > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320440 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4