Hi Have a table where I m having data like below

Now I want to group my data based on only country like below

I has to sum the data based on country only and show remaining columns.
Hi Have a table where I m having data like below

Now I want to group my data based on only country like below

I has to sum the data based on country only and show remaining columns.
Try something like this:
select [Date], [Day], sum([Calls]) as Calls
from MyTable
group by [Date], [Day]
order by [Date]
13 people are following this question.