PIVOT in SQL

USING UNION CLAUSE

SELECT SUM(MALE) MALE,SUM(FEMALE) FEMALE

FROM

(select COUNT(Gender) as Male,0 AS'FEMALE' from Workers WHERE Gender='MALE'

UNION

select 0 AS 'MALE',COUNT(Gender) AS FEMALE FROM Workers WHERE Gender='FEMALE'

)AA

PIVOT

SELECT SUM(MALE) MALE,SUM(FEMALE) FEMALE FROM Workers

pivot

(

  COUNT(GENDER)

  for Gender in (MALE, FEMALE)

) piv