select to group rows

Question

i have a table like this :

Alternative |Total  |Male  |Female
a           |20     |10    |10
b           |50     |20    |30 
c           |40     |10    |30 
c           |30     |15    |15

now i want to select all the rows and the "c" alternative to be grouped.

Answer 1

SELECT Alternative, Sum(Total), Sum(Male), Sum(Female) 
FROM table1 
GROUP BY Alternative

Answer 2

This should suffice

SELECT Alternative, [Total] = SUM(Total), [Male] = SUM(Male), [Female] = SUM(Female)
FROM YourTable
GROUP BY Alternative

Answer 3

Use group by to determine the grouping, then use the appropriate aggregate to process the other fields. I believe in this case that you want to use sum to add the values in each group:

select
   Alternative, sum(Total) as Total, sum(Male) as Male, sum(Female) as Female
from
   TheTable
group by
   Alternative
order by
   Alternative

Answer 4

The following query will select all the rows that are not "c", then group all the rows that are "c", sum their value, and add a single row representing the sum of "c". I hope that's what you mean.

SELECT *
FROM table1 
WHERE Alternative != c

UNION

SELECT Alternative, Sum(Total) as Total, Sum(Male) as Male, Sum(Female) as Female
FROM table1 
WHERE Alternative = c
GROUP BY Alternative

If you just want to group anything that has multiple "Alternative" appearances, just use:

SELECT Alternative, Sum(Total) as Total, Sum(Male) as Male, Sum(Female) as Female
FROM table1 
GROUP BY Alternative