我所写过的最复杂的Sql 语句——合并记录，合并值

select distinct A.word, sum(A.count) as Count


from ( select WORD_B as Word,CO_LIT_COUNT as Count from WORD_RELATION_MATRIX
where WORD_A like '知识管理'
UNION all
select WORD_A,CO_LIT_COUNT from WORD_RELATION_MATRIX where WORD_B like '知识管理') A
group by A.word order by Count desc