|
|
Home » U++ Library support » U++ SQL » OrderBy in descending order [ANSWER FOUND]
|
|
|
|
|
|
Re: OrderBy in descending order [message #13338 is a reply to message #13337] |
Wed, 02 January 2008 11:51 ![Go to previous message Go to previous message](theme/default/images/up.png) ![Go to next message Go to next message](theme/default/images/down.png) |
|
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
|
|
|
|
|
Goto Forum:
Current Time: Sun Jun 16 08:28:26 CEST 2024
Total time taken to generate the page: 0.02410 seconds
|
|
|