U++ forum: Welcome to the forum

Search on this site

Search in forums

Home » U++ Library support » U++ SQL » OrderBy in descending order [ANSWER FOUND]

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Re: OrderBy in descending order [message #13338 is a reply to message #13337]

Wed, 02 January 2008 11:51

unodgs
Messages: 1367
Registered: November 2005
Location: Poland

Ultimate Contributor

From HomeBudget:

        SQL & ::Select(NAME, SqlId("sum(value) as val"))
            .From(MONEY, CATEGORIES)
            .Where(DT_ID == dtid && CAT_ID == ID.Of(CATEGORIES) && PM.Of(MONEY) < 0)
            .GroupBy(CAT_ID)
            .OrderBy(Descending(SqlId("val")));

Just add Descending to OrderBy

Report message to a moderator

[Message index]

		OrderBy in descending order [ANSWER FOUND] By: zsolt on Fri, 01 September 2006 15:39
		Re: OrderBy in descending order By: zsolt on Fri, 01 September 2006 15:45
		Re: OrderBy in descending order By: mirek on Fri, 01 September 2006 18:28
		Re: OrderBy in descending order By: lokki on Sun, 16 December 2007 17:32
		Re: OrderBy in descending order By: mirek on Wed, 02 January 2008 09:03
		Re: OrderBy in descending order By: lokki on Wed, 02 January 2008 11:22
		Re: OrderBy in descending order By: unodgs on Wed, 02 January 2008 11:51
		Re: OrderBy in descending order By: unodgs on Wed, 02 January 2008 11:53
		Re: OrderBy in descending order By: unodgs on Wed, 02 January 2008 11:56

Previous Topic:	How to use Clipboard in HomeBudget(SqLite3)?
Next Topic:	XML Parser has no support for DTD

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Wed Aug 06 09:51:14 CEST 2025

Total time taken to generate the page: 0.03074 seconds