How to show field that not being group?
From: Lemune <alfredosilitonga_at_gmail.com>
Date: Wed, 30 Jul 2008 19:51:47 -0700 (PDT)
Message-ID: <f6778007-3b3b-4366-9c46-20168a0578d9_at_27g2000hsf.googlegroups.com>
Hi all.
Date: Wed, 30 Jul 2008 19:51:47 -0700 (PDT)
Message-ID: <f6778007-3b3b-4366-9c46-20168a0578d9_at_27g2000hsf.googlegroups.com>
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
Received on Thu Jul 31 2008 - 04:51:47 CEST