Oracle SQL语句积累

字段合并：

select EVFOUNDATIONTYPEA || EVFOUNDATIONTYPEB|| EVFOUNDATIONTYPEC ||EVFOUNDATIONTYPED as  b from T_FOUNDATION_SETTING t

合并字段内容并统计：

select a,Count(a)from (
select  EVFOUNDATIONTYPEA as a from T_FOUNDATION_SETTING
union all 
select  EVFOUNDATIONTYPEB  from T_FOUNDATION_SETTING
union all 
select  EVFOUNDATIONTYPEC  from T_FOUNDATION_SETTING
union all 
select  EVFOUNDATIONTYPED  from T_FOUNDATION_SETTING) group by a;

给查询结果增加编号字段：
select rowNum a.* from emp;