;
select * from 
(
       select version,id,comm
              from uib2.r_test
)
pivot
(
    count(id)
    for id in (select 1 as i,2 as j from dual)
)
order by version,comm
;

    count(id)
    for id in (select 1 as i,2 as j from dual)

with table1 as (select '1' as id, 'qwee' as comm, '05.1' as version from dual union all
select 'значение1' as id, 'qwee' as comm, '05.1' as version from dual union all
select 'значение2' as id, 'qwee' as comm, '05.1' as version from dual union all
select 'и' as id, 'qwee' as comm, '05.1' as version from dual union all
select 'так' as id, 'qwee' as comm, '05.1' as version from dual union all
select 'далее' as id, 'qwee' as comm, '05.1' as version from dual

)

select a.*,"значение1","значение2","и","так","далее" from  
(select version, id, comm from table1) a
FULL JOIN (select count(id) as "значение1", id from table1 where id = 'значение1' group by id) b on a.id = b.id
FULL JOIN (select count(id) as "значение2", id from table1 where id = 'значение2' group by id) c on a.id = c.id
FULL JOIN (select count(id) as "и", id from table1 where id = 'и' group by id) d on a.id = d.id 
FULL JOIN (select count(id) as "так", id from table1 where id = 'так' group by id) e on a.id = e.id
FULL JOIN (select count(id) as "далее", id from table1 where id = 'далее' group by id) f on a.id = f.id
where "значение1" is not null 
or "значение2" is not null
or "и" is not null
or "так" is not null
or "далее" is not null