Re: How to show field that not being group?

Lemune wrote:

> Hi all.
>
> I have this data:
>
> id GroupId DDate Value
> 1 1 7/31/2008 5
> 2 1 7/31/2008 6
> 3 1 7/31/2008 2
> 4 2 7/31/2008 1
> 5 2 7/31/2008 2
> 6 2 7/31/2008 1
>
> From this raw dataI want to show the data like this"
> GroupId DDate TotalValue
> 1 7/31/2008 13
> 2 7/31/2008 4
>
> current Query that I Use is
>
> Select D.GroupId,(Select Top 1 DDate From MyTable Where
> GroupId=D.GroupId)As DDate, Sum(D.Value) As TotalValue From MyTable D
> Group By D.GroupId
>
> But I want to remove the subquery, so my query will run faster.
>
> Could it be done?
>
> Thanks in Advanced

Use the Max(...) aggregate function similar to the Sum(...) aggregate you are already using. Received on Thu Jul 31 2008 - 05:11:04 CEST