Use PIVOT Table in SQL Server
Just add empname, gender in table. So let's fill it with some data.
insert into tblGenderEMP values (1, 'mohan', 'M' ,52)
insert into tblGenderEMP values (2, 'mohini', 'F',65)
insert into tblGenderEMP values (3, 'suraj', 'M',500)
insert into tblGenderEMP values (4, 'surya', 'M',600)
insert into tblGenderEMP values (5, 'ragini', 'F',70)
insert into tblGenderEMP values (6, 'rohini', 'F',250)
insert into tblGenderEMP values (7, 'raju', 'M',320)
Now if we select then display like:
select * from tblGenderEMP
Result
| Empid | Empname | Gender | AMT |
| 1 | Mohan | M | 52 |
| 2 | Mohini | F | 65 |
| 3 | Suraj | M | 500 |
| 4 | Surya | M | 600 |
| 5 | Ragini | F | 70 |
| 6 | Rohini | F | 250 |
| 7 | Raju | M | 320 |
To find out how may amount contribute in Male and How many amount contribute Female:
| M | F |
| 1472 | 385 |
Your Quey become as:
SELECT [M], [F]
FROM
(
SELECT sp.gender,sp.amt
FROM tblGenderEMP as sp
) p
PIVOT
(
SUM (amt)
FOR gender
IN ([M], [F])
) AS pvt
