He added the order by desc, so that it sorted the highest to lowest.. Had it been asc, you would have gotten the four smallest returns. Rob
On Wed, Sep 24, 2008 at 4:52 PM, Fawzi Amadu <[EMAIL PROTECTED]> wrote: > Sorry for the premature posting I mistakenly hit the enter key. Now to my > question > > > Hi S. Isaac, > this worked fine after some tweeking. Currently my first query returns 24 > rows of > records (because there are currently for constituencies returning results > and > each has 6 parties participating)so I had to change the Maxrows to 4 to get > the desired result. However the logic beats me, how is it that your SQL > returns only the > maximum on each row? I will appreciate some the lesson. Thanks. > > NB: Thanks to Raymond as well I learnt some more about Q of Q's > > > > >> Well, I guess if you want to _read_ and all. ;) > > > >It's easier to find the time to read when you've got a smaller number of > >open source project emails to respond to. ;) > > > >-- > >s. isaac dealey ^ new epoch > > isn't it time for a change? > > ph: 781.769.0723 > > > >http://onTap.riaforge.org/blog > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:313032 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
