Distinct y union ?

[Thumper]

Creo que esto te puede servir:

declare @table table ( intID int, varNom varchar(50), varTit1 varchar(20), varTit2 varchar(20), varTit3 varchar(20) )
insert into @table values( 1, 'Eduardo', 'Oracle', 'PW', 'Office' )
insert into @table values( 2, 'Luisito', 'ASP', 'PHP', 'SQL SERVER' )
insert into @table values( 3, 'Juanito', 'MySQL', 'PHP', 'ASP' )
insert into @table values( 4, 'Sonia', 'Oracle', 'Office', 'Oracle' )

SELECT varTit, num = SUM(num)
FROM (
select pos = 'a', varTit = varTit1, num = count(*)
from @table
group by varTit1
UNION
select pos = 'b', varTit = varTit2, num = count(*)
from @table
group by varTit2
UNION
select pos = 'c', varTit = varTit3, num = count(*)
from @table
group by varTit3) Y
GROUP BY varTit
order by 2 desc

saludos